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

85 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
doormat105907(None) 
doorman1037061doorman
doormats1145411doormats
doormen1036752doormen
doorway1444242doorway
dormant102814372d_ormant
format113021352_format
bookman15136483bookman
cocomat13413623cocomat
colorman1247893colorman
deorbit1048173deorbit
derat65044083d_er_at
derma84918513d_erma_
dermal93614343d_ermal
dermas94116813d_ermas
dharma1276103dharma_
dharmas1356513dharmas
dhoora1035653dhoor_a_
dhooras1135943dhoor_as
diorama1046533diorama
dioramas1145513dioramas
doat56947673d_o__at
dobra85013103dobr_a_
dobras94811913dobr_as
dogma96112463d_ogma_
dogmas105011243d_ogmas
dogmata1145143d_ogmata
dolma86214173d_olma_
dolman95312403d_olman
dolmas95213043d_olmas
domal85619203d_o_mal
doodad936423doo_dad
doom76430073doo_m__
doomed104113293doo_med
dooms85321343doo_m_s
doomy116018263doo_m_y
door56928513door___
doorjamb2051453doorjamb
doornail943573doornail
doorplate1243773doorplate
doorpost1165453doorpost
doors65022133door__s
doorways1544043doorways
doorwoman1552713doorwoman
dooryard1343373dooryard
dorm76834633d_orm__
dormer94415903d_ormer
dormie9312623d_ormie
dormin9312313d_ormin
dorms85723843d_orm_s
dormy115817473d_orm_y
dorsa64617283d_orsa_
dorsad8408973d_orsad
dorsal74613943d_orsal
douma85817703d_ouma_
doumas95314813d_oumas
doura66518663dour_a_
dourah10479813dour_ah
douras75016723dour_as
dourest8312943dourest
drat56247833d__r_at
durmast1037623d_urmast
footman1236403footman
forgat104018583_forgat
formal113215203_formal
formant123416003_formant
formate123115093_formate
formats123113573_formats
goodman1135933goodman
gooral7310463goor_al
gourmet1059203gourmet
hoorah124411113hoor_ah
hooray123011373hoor_ay
korat94934433_kor_at
korma115913073_korma_
kormas124511233_kormas
motorman1246143motorman
normal83213533_normal
odorant8411393odorant
poorest9312773poorest
reformat1357653reformat
roommate1244863roommate
woodman1336313woodman
woolhat1346043woolhat
woolman1235433woolman

Search took 7 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 Filter1786911340270.1401276364.3
2DLD Change Limit134027856.67020094.0
3Display Results85850.0165312.5
 (SQL Overall)178691856.82626178.0
 
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.