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

68 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
condemner144576(None) 
condemned1545101condemned
condemners1546021condemners
condemnor1443591condemnor
contemner1347181contemner
condemn1237112condemn__
condemnors1543952condemnors
condemns1336292condemn_s
condenser1287412condenser
condoner112913412cond_oner
congener112412202conge_ner
contemned1446792contemned
contemners1447072contemners
contemnor1344642contemnor
convener132913162conve_ner
codeine103815033co_deine_
codeines113114523co_deines
comember1644163co_member
concealer1368223concealer
conceder1338743conce_der
conceiver1657413conceiver
concenter13312213concenter
concerned1438643concerned
condemning1665743condemning
condense1179613conde_nse
condensed1387113condensed
condensers1386373condensers
condenses12710133condenses
condiment14410853condiment
condoler113412123cond_oler
condone102616293cond_one_
condoned122612023cond_oned
condoners122811513cond_oners
condones112817393cond_ones
conducer13127373cond_ucer
conferrer1447063conferrer
confiner13311193con_finer
congealer1256703congealer
congeners122511133conge_ners
conjoiner1855933conjoiner
connecter1349053connecter
conner84423963con___ner
consenter11312493consenter
conserver1448723conserver
consigner1246633consigner
consumer1238503consum_er
container11311073container
contemn1137803contemn__
contemnors1445243contemnors
contemns1237403contemn_s
contender1239563contender
contester11311183contester
convene123314323conve_ne_
convened143412223conve_ned
conveners142911443conve_ners
convenes132916913conve_nes
convenor13307613conve_nor
converser1438093converser
converter14311013converter
conveyer16278143conve_yer
cozener18328953co_ze_ner
goldener1045403golde_ner
moderner1145523mo_derner
nonmember1543123nonmember
ponderer112410193ponde_rer
solemner1045053so_lemner
wonderer12249183wonde_rer
woodener1245763woode_ner

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 Filter1786911486410.423422437.4
2DLD Change Limit148641686.39023261.5
3Display Results68680.0302266.7
 (SQL Overall)178691686.84326113.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.