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

189 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
condemn123711(None) 
condemns1336291condemns
contemn1137801contemn
bondmen1237892bondmen
codein94916722co_dein
coden86128542co_de_n
concern113011962concern
condemned1545102condemned
condemner1445762condemner
condemnor1443592condemnor
condign1147732condign
condom114215362condom_
condoms124214082condoms
contemns1237402contemns
bonded104719953bonde_d
bonder95324783bonde_r
bonders104120663bonders
bondman1238043bondman
bondsman1345693bondsman
bondsmen1345473bondsmen
bounden10389453bounde_n
candela1089743candela
candent10417363candent
canteen9411083canteen
cinder94119123cinde_r
cinders104617763cinders
cindery13429193cindery
cinema1047653cin_ema
codded114515303codde_d
codder104416343codde_r
codders114114453codders
code77347733co_de__
codec107120343co_de_c
codecs115112933co_decs
coded95433183co_de_d
codeia94112193co_deia
codeina104010323co_deina
codeine103815033co_deine
codeins103715483co_deins
codens94821013co_dens
coder86134223co_de_r
coders95426983co_ders
codes86247293co_de_s
codex155817583co_de_x
codlin94516443co_dlin
codon86522853co_d_on
cognomen1346083cognomen
colder95121853colde_r
coldest102514763coldest
colleen939543colleen
column1038103co_lumn
conceal113313023conceal
concede12310103concede
conceit113218073conceit
concent114422513concent
concept133314443concept
concerns122710833concerns
concert113325223concert
condemners1546023condemners
condemning1665743condemning
condemnors1543953condemnors
condense1179613condense
condiment14410853condiment
condo85322593cond__o
condoes104319203condoes
condole102914953condole
condone102616293condone
condor94616973cond_or
condors104018573condors
condos94322333cond_os
conduce12139233conduce
conduct121411593conduct
conduit10713083conduit
condyle13247053condyle
cone67256963con_e__
coned86040053con_e_d
cones76457423con_e_s
coney105932883con_e_y
coneys115218423con_eys
confect143614273confect
confer114018683confe_r
confers124120093confers
confess12399903confess
conge85227593conge__
congeal104011683congeal
congee96024473conge_e
congeed113212313congeed
congees103517923congees
conger95024273conge_r
congers104223233congers
conges94928173conge_s
congest104618773congest
conidian1168383conidian
conies84338593conie_s
conin76232723con__in
conium10415313conium_
coniums11311863coniums
conjoin1638203conjoin
conked135019113conke_d
conker124721553conke_r
conkers133721043conkers
conn66229133con___n
connect113515743connect
conned95119703conne_d
conner84423963conne_r
conners94023113conners
consent93723113consent
consign1038773consign
consume11510133consume
contain9315833contain
conte76633203conte__
contemned1446793contemned
contemner1347183contemner
contemnor1344643contemnor
contempo1444833contempo
contempt1447473contempt
contend103511893contend
content94326153content
contes84432913conte_s
contest93523233contest
context163913433context
convect143114483convect
convene123314323convene
convent123919413convent
convert123721473convert
convex18367743conve_x
convey144610223conve_y
conveys15308223conveys
copen94826433co_pe_n
corded105923353corde_d
corder94322883corde_r
corders104520883corders
cordon95017293cord_on
coude85022633coude__
coven106925043co_ve_n
cowmen13810923cowme_n
cozen165019703co_ze_n
cundum1136513cundum_
cundums1235183cundums
fonded115717043fonde_d
fonder104120063fonde_r
fondest11312403fondest
goddamn1242673goddamn
golden84411153golde_n
goodmen1135623goodmen
hodden113811453hodde_n
hoiden103612333hoide_n
holden104113953holde_n
hordein1138753hordein
hoyden13328933hoyde_n
landmen1038553landmen
linden7411453linde_n
loden66621143lo_de_n
louden73711793loude_n
modem103717143mo_dem_
modems114610763mo_dems
modern939523mo_dern
monde85723143monde__
mondes94322353monde_s
nondemand1344753nondemand
nonheme1247133nonheme
nonmen8412833nonme_n
odeon6411483_o_deon
oedema936573_oedema
olden65114853_olde_n
ponded105218773ponde_d
ponder94521693ponde_r
ponders103618843ponders
rodmen939713ro_dmen
rondeau846813rondeau
rondel73212643ronde_l
rondels82510053rondels
sandmen1039413sandmen
sodden84011513sodde_n
solemn838643so_lemn
sonde64622833sonde__
sonder73623523sonde_r
sonders83820713sonders
sondes74922873sonde_s
soundmen1145233soundmen
tandem9311413tandem_
tandems1037633tandems
toneme8312103ton_eme
tongmen1037123tongmen
wonder103617813wonde_r
wonders113315993wonders
wooden103610303woode_n
woodmen1356053woodmen
yonder103214133yonde_r

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.390458182.1
2DLD Change Limit1340271896.15621771.8
3Display Results1891890.0633000.0
 (SQL Overall)1786911896.60927037.5
 
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.