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

107 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
motorise1031152(None) 
motorised1247261motorised
motorises11311671motorises
motorist10314411motorist
motorize19410431motorize
memorise121411432memorise
moonrise1046782moonrise
moorish123311782mo_orish
motorbike1743302motorbike
motoric11312222motori_c
motoring11410952motoring
motorists1149912motorists
motorized2148662motorized
motorizes20410782motorizes
motors84616602motor_s_
actorish1349433actorish
aphorise1339983aphorise
atomise93013823_atomise
authorise1248023authorise
boorish123712593bo_orish
botanise1039643botanise
colonise102514283colonise
colorism122112433colorism
colorist102818993colorist
colorize192314203colorize
comprise14310813comprise
coterie9417403coteri_e
coteries10422703coteries
melodise1147593melodise
memories121214353memories
memorised14118223memorised
memorises131211583memorises
memorize211311103memorize
metalise10416053metalise
meteorite1148173meteorite
methodise1545513methodise
metrist9317063met_rist
mitosis939633mitosis_
mobilise1248143mobilise
modernise1244733modernise
moisturise1253253moisturise
monetise10311473monetise
monitories1248893monitories
monodies11312503monodies
monodist11310923monodist
monokine1448483monokine
monoxide1846293monoxide
moonish123311043mo_onish
moonrises1146723moonrises
moorage1038743mo_orage
moorier93113073mo_orier
mooriest102812723mo_oriest
mooring102514443mo_oring
moors74923143mo_or_s_
moose76327193mo_o__se
moperies12313873moperies
moralise10314913moralise
moronism1249323moronism
morose85116243m__orose
morris83814733mo_rris_
morrises10711073mo_rrises
morse76032703m__or_se
mortise9713533mo_rtise
mothlike1736063mothlike
motile83818343mot__ile
motive113112143mot__ive
motocross1344223motocross
motor75317293motor___
motorbiked1952163motorbiked
motorbikes1852873motorbikes
motorbus1244443motorbus
motorbuses1443743motorbuses
motorcade1443933motorcade
motorcar1274543motorcar
motordom1344293motordom
motored1039933motor_ed
motorings1245973motorings
motorising1347513motorising
motorless1145723motorless
motorman1246143motorman
motormen1245703motormen
motorway1643503motorway
notaries8314933notaries
notarize1749293notarize
notornis845693notornis_
odorize1737403_odorize
oorie53026363_o_ori_e
ozonise1646443_ozonise
polarise10513903polarise
pooris83916843po_oris_
poorish123712303po_orish
rotaries8315693rotaries
rotors64917953rotor_s_
satirise8310683satirise
satoris7317253satoris_
solarise8512543solarise
stories7324273_stories
theorise1137873theorise
tories65435883__tories
torose64317693__torose
torse55833333__tor_se
tortoise847093torto_ise
totalise8312503totalise
valorise112110303valorise
vaporise13209633vaporise
votaries11312013votaries
votarist111012163votarist

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.453394461.4
2DLD Change Limit1461621076.61022112.3
3Display Results1071070.0631698.4
 (SQL Overall)1786911077.12625075.9
 
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.