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

109 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
colluders1228561(None) 
colliders12298071colliders
colluder11276871colluder_
colludes11279221collude_s
colanders1238012colanders
coleaders1237822coleaders
collegers12256842collegers
collider113410422collider_
collides113214472collide_s
colliers103613582coll_iers
collude10337992collude__
colluded12296462collude_d
colourers1136472colourers
concluders1543492concluders
polluters1135032polluters
alludes83610333_allude_s
allurers8286773_allurers
boulders113010033boul_ders
bowlders14306493bowl_ders
calenders1237403calenders
callers94221963call__ers
callipers1356493callipers
calluses1039323calluse_s
cellarers11236503cellarers
cellulars1144133cellulars
cellules1036813cellule_s
clouters10399803c_louters
clowders14357473c_lowders
coalers94419353coal__ers
codders114114453co__dders
coders95426983co___ders
cofounders1643333cofounders
coholders1535623coholders
coilers93619903coil__ers
colander1139033colander_
colder95121853co_l_der_
coleader1139183coleader_
coleuses1039723coleuse_s
collagens12256033collagens
collages113514243collage_s
collarets11327333collarets
collars93816573coll__ars
collates103019143collate_s
collators11410343collators
colleens1036843coll_eens
colleger11227933colleger_
colleges112410523college_s
collets93517903coll__ets
collide103214793collide__
collided12309803collide_d
collier93618153coll_ier_
colliery13307363coll_iery
collies94326583coll_ie_s
colluding1335903colluding
colorers10312183co_lorers
colourer1037563colourer_
colours95913443colou__rs
colters93522443co_l_ters
columels1244813co_lumels
colures9315143co_lure_s
communers15338413communers
commuters15378913commuters
computers15339753computers
conceders1437953conceders
concluder1444183concluder_
concludes1445143conclude_s
conducers14136563conducers
confiders1537483confiders
confuters1437793confuters
conjurers18126233conjurers
conquers1938223conqu_ers
considers1238933considers
consumers1337203consumers
coolers93522493cool__ers
corders104520883co__rders
corulers1039773co_rulers
costumers1374853costumers
coulters103614313coul_ters
couters93827303co__uters
cullenders1343193cullenders
cullers93418853cull__ers
cylinders1543203cylinders
deluders10156433_deluders
eluders8409903__eluders
excluders1942713excluders
folders113514393fo_l_ders
followers15146183followers
holders113715903ho_l_ders
hollers103818233holl__ers
illudes8347553_illude_s
jolliers15357433joll_iers
lauders84012893__lauders
lollers72713793loll__ers
molders103315553mo_l_ders
moulders11348343moul_ders
occludes1363103occlude_s
polders103617373po_l_ders
pollers93420023poll__ers
pollsters1137173pollsters
polluter1035403polluter_
pollutes1037613pollute_s
preluders1234423preluders
rollers73117473roll__ers
rollovers1244093rollovers
scolders11288993sco_l_ders
solanders1036963solanders
solders83517773so_l_ders
tollers73217463toll__ers
volleyers1542773volleyers

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 Limit1486411096.34323433.9
3Display Results1091090.0462369.6
 (SQL Overall)1786911096.81226231.8
 
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.