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

123 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
coholder143606(None) 
coholders1535611coholders
beholder1435052beholder
choler113717152c_hol_er
chowder16387802c_howder
colder95121832c__older
cooler84824712co_ol_er
copyholder2152252copyholder
holder104619652__holder
inholder1276102inholder
jobholder2242242jobholder
potholder1544762potholder
upholder1444082upholder
beholden1443593beholden
beholders1544933beholders
bolder94820933__bolder
bondholder1753093bondholder
boodler103312003bo_odler
boulder103411343bo_ulder
bowlder13407473bo_wlder
cajoler16398393cajol_er
cardholder1753173cardholder
caroler93816753carol_er
caroller1039203caroller
cheder125113493c_h_eder
chider125116053c_h_ider
childe124711213c_hilde_
childes134211273c_hildes
chiller124112183c_hiller
choicer14197893c_hoicer
choker154314373c_ho_ker
chokier1638043c_hokier
cholera12409093c_hol_era
cholers124215193c_hol_ers
chomper163810073c_homper
chooser124412963c_hooser
choosier1337163choosier
chopper163611893c_hopper
chorded144710553c_horded
chouser125212943c_houser
chowders17387533c_howders
chudder14245943c_hudder
clowder13367933c_lowder
coaler84121703co_al_er
coalier93416173co_alier
cobbler133311823cobbl_er
codder104416333c__odder
coddler113710823coddl_er
coder86134213c__o_der
cofounder1543823cofounder
coheaded1536603coheaded
coherer122912783coh_erer
cohoshes1635873cohoshes
cohosted1436133cohosted
coiler84421593co_il_er
colander1139033colander
coleader1139173coleader
collider113410413collider
collier93618153co_llier
colluder11276863colluder
colorer9312523colo_rer
colourer1037553colourer
colter84625093c__olter
comelier12310653comelier
complier14310253complier
conceder1338733conceder
concluder1444173concluder
condoler113412113condol_er
confider1438123confider
consider11310393consider
consoler102812613consol_er
cooer74831013co_o__er
cooker124722453co_o_ker
cooled95224583co_ol_ed
coolers93522493co_ol_ers
coolie83821603co_olie_
coolies93824963co_olies
cooper104221123co_o_per
cooter85128613co_o_ter
copolymer1843193copolymer
copyholders2252163copyholders
corder94322873c__order
coroner94218203coro_ner
coruler9311713corul_er
costlier1038523costlier
coulter94115593co_ulter
coupler114713013coupl_er
coworker1744683coworker
crowder13389843c_rowder
doodler93310153do_odler
enfolder1286153enfolder
folder104317543__folder
gasholder1443823gasholder
golder84417603__golder
holden104113953__holden
holders113715903__holders
holier94921623__holier
holler93520613__holler
infolder1256423infolder
inholders1345333inholders
jobholders2352173jobholders
molder93819273__molder
moulder10389803mo_ulder
older65121173___older
penholder1544413penholder
pewholder1842723pewholder
polder94019253__polder
pooler83819843po_ol_er
potholders1644333potholders
resolder9259233resolder
scolder103210333_scolder
shoulder1234753shoulder
smolder10327753_smolder
solder73921343__solder
tooler63818613to_ol_er
toolholder1452793toolholder
unfolder12216583unfolder
unholier1137283unholier
unsolder937213unsolder
upholders1543643upholders
vocoder1334693voco_der
wooler93615873wo_ol_er
woolier103612353wo_olier

Search took 10 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.203880251.2
2DLD Change Limit1461621238.97016294.5
3Display Results1231230.0462673.9
 (SQL Overall)1786911239.21919382.9
 
Comments and Suggestions welcome: FaceBook ~ UserVoice ~ SQLServerCentral  |  Developed By: Tom Keller Consulting © 2011-2024  |  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.