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

106 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
coholders153562(None) 
coholder1436071coholder_
beholders1544932beholders
cholers124215202c_hol_ers
chowders17387542c_howders
coolers93522492co_ol_ers
copyholders2252172copyholders
holders113715902__holders
inholders1345352inholders
jobholders2352172jobholders
potholders1644342potholders
upholders1543642upholders
beholder1435053beholder_
bondholders1852833bondholders
boodlers113710743bo_odlers
boulders113010033bo_ulders
bowlders14306493bo_wlders
cajolers17267133cajol_ers
cardholders1852993cardholders
carolers103314173carol_ers
carollers1137703carollers
cheders134512393c_h_eders
chiders135312943c_h_iders
childes134211273c_hilde_s
chillers133710923c_hillers
chokers164311523c_ho_kers
choler113717153c_hol_er_
cholera12409093c_hol_era
choleras13289043c_hol_eras
chompers17369593c_hompers
choosers134810883c_hoosers
choppers174110463c_hoppers
chousers134610203c_housers
chowder16387813c_howder_
chudders15235563c_hudders
clowders14357473c_lowders
coalers94419353co_al_ers
cobblers14359593cobbl_ers
codders114114453c__odders
coddlers12359173coddl_ers
coders95426983c__o_ders
cofounders1643333cofounders
coherers132310733coh_erers
cohoshes1635883cohoshe_s
cohostess1443463cohostess
coilers93619903co_il_ers
colanders1238013colanders
colder95121853c__older_
coleaders1237823coleaders
colliders12298073colliders
colliers103613583co_lliers
colluders12285613colluders
colorers10312183colo_rers
colourers1136473colourers
colters93522443c__olters
compliers1538293compliers
conceders1437953conceders
concluders1543493concluders
condolers122710573condol_ers
confiders1537483confiders
considers1238933considers
consolers112510923consol_ers
cooers84324563co_o__ers
cookers134619463co_o_kers
cooler84824713co_ol_er_
coolies93824963co_olie_s
coolness1037743co_olness
coopers114019483co_o_pers
cooters94525733co_o_ters
copolymers1943103copolymers
copyholder2152253copyholder_
corders104520883c__orders
coroners104016233coro_ners
corulers1039773corul_ers
coulters103614313co_ulters
couplers123311323coupl_ers
coworkers1854363coworkers
crowders14398813c_rowders
doodlers10338843do_odlers
enfolders1395093enfolders
folders113514393__folders
gasholders1543813gasholders
holder104619653__holder_
hollers103818233__hollers
infolders1385173infolders
inholder1276113inholder_
jobholder2242243jobholder_
molders103315553__molders
moulders11348343mo_ulders
penholders1643793penholders
pewholders1942703pewholders
polders103617373__polders
poolers94217423po_ol_ers
potholder1544763potholder_
resolders10258013resolders
scolders11288993_scolders
shoulders1334233shoulders
smolders11287193_smolders
solders83517773__solders
toolers74416503to_ol_ers
toolholders1552513toolholders
unfolders1344723unfolders
unsolders1064693unsolders
upholder1444083upholder_
vocoders1434243voco_ders
woolers104214023wo_ol_ers

Search took 8 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 Limit1486411066.95321378.0
3Display Results1061060.0303533.3
 (SQL Overall)1786911067.40624127.9
 
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.