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 “motorless” with Change Limit: [1] [2] [3] [4]

You can choose a higher Change Limit to return more words, although it will take longer.
to automatically increase the Change Limit after seconds.

84 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
motorless114572(None) 
colorless1145682colorless
doctorless1342582doctorless
doorless936712do_orless
moonless10278042mo_onless
mortarless1243102mortarless
motherless1544092motherless
motionless1243482motionless
motorises11311672motorises
odorless934172_odorless
armorless1143483armorless
boonless10328353bo_onless
bootless103410983bo_otless
bottomless1442053bottomless
cookless14258633co_okless
cotterless1244033cotterless
coverless1436803coverless
dowerless1344013dowerless
emotionless1352853emotionless
errorless942813errorless
floorless1243793floorless
foodless12338383fo_odless
footless113710803fo_otless
hoodless12289733ho_odless
hoofless14258013ho_ofless
hookless151238363ho_okless
hoopless13279263ho_opless
hotpress1344303hotpr_ess
humorless1442963humorless
matchless1644683matchless
mateless102711293mat_eless
matless93014043mat__less
mattress1036533mattr_ess
mayoress1344383mayor_ess
moneyless1444653moneyless
monocles12310673monocle_s
mooleys1236863mo_o_leys
moonlets10247473mo_onlets
moorhens1344853mo_orhens
mooriest102812723mo_oriest
mootness1036753mo_otness
motiles93317433mot_ile_s
motiveless1542963motiveless
motleys1235683mot__leys
motocross1344223motocross
motorbus1244443motor_bus
motorbuses1443743motorbuses
motorcars1394473motorcars
motordoms1444093motordoms
motored1039933motor_e_d
motorings1245973motorings
motorise10311523motor_ise
motorised1247263motorised
motorist10314413motor_ist
motorists1149913motorists
motorizes20410783motorizes
motormen1245703motorme_n
motors84616603motor___s
motorways1742873motorways
mottlers10388183mot_tlers
mottles93415803mot_tle_s
mouthless1444713mouthless
moveless1367753mo_veless
noteless839403not_eless
oarless73913373_o_arless
poorness1036363po_orness
powerless1444293powerless
roofless11316733ro_ofless
rootless83910443ro_otless
savorless1243213savorless
starless81610843_starless
toeless72612393__toeless
toolless836343to_olless
toothless1244683toothless
topless92511123__topless
toyless10268713__toyless
tutoress845093tutor_ess
vaporless1443163vaporless
visorless1243143visorless
votaress1144223votar_ess
voteless1137493vot_eless
votress1035483vot_r_ess
waterless1238013waterless
woodless12278453wo_odless

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 Filter1786911486410.423422437.4
2DLD Change Limit148641847.59319576.1
3Display Results84840.0302800.0
 (SQL Overall)178691848.04622208.7
 
Comments and Suggestions welcome: FaceBook ~ UserVoice ~ SQLServerCentral  |  Developed By: Tom Keller Consulting © 2011-2026  |  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.