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 “motorist” 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.

105 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
motorist1031441(None) 
motorise10311521motorise
motorists1149911motorists
colorist102818992colorist
metrist9317062met_rist
monodist11310922monodist
mooriest102812722mo_oriest
moorish123311782mo_orish
motoric11312232motori_c
motoring11410952motoring
motorised1247262motorised
motorises11311672motorises
motorize19410432motorize
motors84616602motor_s_
votarist111012162votarist
actorish1349443actorish
altoist7313393alto_ist
amorist9317643_amorist
aorist64827873__aorist
aphorist13412513aphorist
arborist10411613arborist
atomist92915763_atomist
boorish123712593bo_orish
botanist10412033botanist
colonist102617933colonist
colorism122112433colorism
colorists112313593colorists
ecotourist1253733ecotourist
florist10314243_florist
footrest11308853footrest
futurist1148283futurist
humorist1348783humorist
lookist1139563lo_okist
maturest1039703maturest
meliorist1148463meliorist
melodist1149743melodist
memoirist1345983memoirist
memorise121411433memorise
metalist10519353metalist
methodist1547023methodist
metrists1039853met_rists
mitosis939633mitosis_
modelist11310503modelist
modernist1246263modernist
moist76033583m__o_ist
monetarist1258333monetarist
monist84324983m__onist
monodists1247703monodists
monotint10413713monotint
moodiest112712183mo_odiest
mooniest103014173mo_oniest
moonish123311043mo_onish
moonrise1046783moonrise
moorier93113073mo_orier
mooring102514443mo_oring
moors74923143mo_or_s_
moralist10316663moralist
moronism1249323moronism
morris83814733mo_rris_
mothiest13311033mothiest
motliest10310773motliest
motocross1344223motocross
motor75317293motor___
motorbike1743303motorbike
motorboat1355063motorboat
motorbus1244443motorbus
motorcar1274543motorcar
motordom1344293motordom
motored1039933motor_ed
motorings1245973motorings
motorising1347513motorising
motorized2148663motorized
motorizes20410783motorizes
motorless1145723motorless
motorman1246143motorman
motormen1245703motormen
motorway1643503motorway
myologist15411093myologist
naturist8410813naturist
notoriety1244033notoriety
notornis845693notornis_
oboist8312683_obo_ist
ologist8313833_ologist
oologist9313493oologist
otocyst1244833_otocyst
poloist91016323polo_ist
poorest9312773po_orest
pooris83916843po_oris_
poorish123712303po_orish
posturist11410443posturist
rigorist949123rigorist
rotors64917953rotor_s_
satirist8313503satirist
satoris7317253satoris_
sitarist8315283sitarist
sodomist1157633sodomist
soloist7915893solo_ist
tenorist8413023tenorist
theorist1149553theorist
totalist8315583totalist
totemist1049033totemist
tourist7313203to_urist
utopist938693_utopist
votarists1298603votarists
zootomist2045863zootomist

Search took 8 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.483369960.7
2DLD Change Limit1461621057.44019645.4
3Display Results1051050.0462282.6
 (SQL Overall)1786911057.96922423.3
 
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.