Welcome!   |  Search Scrabble® Dictionary using DLD   |  Statistics   |  Compare any two Strings using DLD   |  Reference   |  Your IP

Dictionary Search Results using Damerau-Levenshtein distance in T-SQL

Here are the results of your fuzzy-string dictionary search for “manorial” with Change Limit: [1] [2] [3]

(Found more than 100 similar words, so Change Limit cannot be increased.)
to automatically search another random word after seconds.

117 similar words found! Changes to Transform each Found Word to your word are shown as:
 remove a letter ~ replace a letter ~ swap two letters ~ _add a letter from your word
(Use the links in the Changes column to see more Transformation details.)

Found WordScrabble ScoreSearched PreviouslyFound PreviouslyChangesTo Transform to your Word
manorial1031108(None) 
manurial1047791manurial
cantorial1149812cantorial
malarial10410612malarial
mandril1049352mandri_l
mandrill1146612mandrill
manubrial1342942manubrial
material10314102material
mayoral1237692mayor_al
memorial1249522memorial
monomial12410132monomial
monorail1059772monorail
rasorial848222rasorial
abnormal1244093abnormal
aboral8314373_abor_al
aerial64625713_a_erial
alodial899953_alodial
amoral8314633_amor_al
anodal72512123_ano_dal
anopia83412393_anopia_
anopias92412483_anopias
anorak1038923_anor_ak
anoxia133510023_anoxia_
anoxias14259113_anoxias
antral65719413_antr_al
anural65714743_anur_al
anuria6313123_anuria_
anurias7312253_anurias
aortal65217513_a_ortal
aporia8315863_aporia_
aporias9315153_aporias
armorial1049453armorial
asocial998653_asocial
atrial65418943_a_trial
baronial1049483baronial
binomial1246223binomial
canonical1347213canonical
caporal11410943capor_al
censorial11117503censorial
chorial124214143_chorial
factorial1447033factorial
ganglial1054663ganglial
handrail1247303handrail
janitorial1744463janitorial
madrigal121627253ma_drigal
magnolia1144793magnolia_
magnolias1244723magnolias
mahonia1238443mahonia_
mahonias1348063mahonias
majoring1836363majoring
majority2044663majority
malaria9313703malaria_
malarian10311563malarian
malarias10313773malarias
managerial1354253managerial
mandrel1038683mandr_el
mandrills1245453mandrills
mandrils1138493mandrils
mania75634153man__ia_
maniac103917973man__iac
maniacal1246723maniacal
manias84029033man__ias
manila84518303man__ila
manor78023933manor___
manorialism1574983manorialism
manors84420883manor__s
mantra84116093mantr_a_
mantram114011603mantr_am
mantrap11379823mantr_ap
mantras93815863mantr_as
mantric11311353mantri_c
manual8313463man__ual
manubria1243493manubria_
manuring1139223manuring
maria75032883ma__ria_
marital92314183ma__rital
marmoreal1343733marmoreal
martial92415413ma_rtial
materials11510803materials
materiel10311253materiel
maternal1047803maternal
matronal1048113matronal
memorials1346563memorials
menial84223033men__ial
menorah1247933menor_ah
mineral9312733miner_al
minorca1145223minorca_
minorcas1245973minorcas
minoring11311473minoring
minority1347933minority
minutial1046423minutial
mistrial10311383mistrial
monaxial1745963monaxial
monitorial1246733monitorial
monodical1447003monodical
monofil1247273monofi_l
monomials1347313monomials
monorails1148743monorails
moral75533433m__or_al
mortal84616853m__ortal
narial6317953__narial
nonoral7313603nonor_al
noria55722183__noria_
norias65518203__norias
normal83213533__normal
raptorial1147433raptorial
sangria838113sangria_
sangrias938373sangrias
sartorial948383sartorial
sensorial9117453sensorial
synovial1444743synovial
tensorial9116793tensorial
tentorial9119603tentorial
tenurial847703tenurial
tonsorial9116743tonsorial
tutorial847833tutorial
uxorial1446323_uxorial

Search took 9 seconds overall (including website activity, plus SQL activity in the following phases):

  1. Length Filter: Limit the application of DLD to words with length difference of no more than the Change Limit.
  2. DLD Change Limit: Apply DLD to each remaining word, limiting each comparison according to the Change Limit.
  3. Display Results: Return the results, with similar words marked up to highlight differences.
SeqSearch PhaseWords CheckedWords MatchedSecondsWords Per Sec
1Length Filter1786911461620.423422437.4
2DLD Change Limit1461621177.79618748.3
3Display Results1171170.0303900.0
 (SQL Overall)1786911178.24921662.1
 
Comments and Suggestions welcome: FaceBook ~ UserVoice ~ SQLServerCentral  |  Developed By: Tom Keller Consulting © 2011-2025  |  Published At: SQLServerCentral (with Source Code)  |  Presented At: SQLSaturday #144  |  Demonstrated For: Sacramento SQL Server User Group  |  Developed For: Repo Remarketing  |  Running On: Microsoft SQL 2014 RTM Standard on Server 2012 R2 (also successfully run on SQL 2012 Web Edition, SQL Express 2008-2008R2, and SQL Server 2000-2005 Standard)  |  SQL Performance Monitoring By: Confio Ignite  |  American Scrabble® Dictionary From: Internet Scrabble Club  |  Scrabble® is a registered trademark. All intellectual property rights in and to the game are owned in the U.S.A and Canada by Hasbro Inc., and throughout the rest of the world by J.W. Spear & Sons Limited of Maidenhead, Berkshire, England, a subsidiary of Mattel Inc. Mattel and Spear are not affiliated with Hasbro. This site is not affiliated with Scrabble®, Mattel, Spear, or Hasbro in any way. This site is for entertainment and technical education purposes only.