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

132 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
confiders153748(None) 
confider1438121confider_
confides14310571confide_s
confiners1439951confiners
considers1238931considers
colliders12298072colliders
conceders1437952conceders
confers124120092conf__ers
confide13310202confide__
confided1537452confide_d
confident1549382confident
confiner13311192confiner_
confines13315652confine_s
confirmers1744962confirmers
confiteors1543822confiteors
confuters1437792confuters
conifers133611702con_ifers
connivers1436932connivers
consider11310392consider_
bonders104120663bon__ders
bonfires1367383bonfire_s
candider1237343candider_
chiders135312943c__hiders
ciders94620093c___iders
cinders104617763cin__ders
codders114114453co__dders
coders95426983co___ders
codifiers1555343codifiers
codrivers1544863codrivers
coffers154112693co_f_fers
cognizers2164433cognizers
coholders1535623coholders
coilers93619903co__ilers
coincides1446433coincide_s
coiners93620753co__iners
coinfers13349503coinf__ers
colanders1238013colanders
coleaders1237823coleaders
collider113410423collider_
collides113214473collide_s
colliers103613583colli_ers
colluders12285613colluders
combiners15247943combiners
comfier1439163comfi_er_
comfiness1646953comfiness
compilers1537053compilers
conceder1338743conceder_
concedes13311063concede_s
conceivers1746313conceivers
conciser12310243conciser_
concluders1543493concluders
condolers122710573condolers
condoners122811513condoners
condors104018573con__dors
conducers14136563conducers
confederal1653923confederal
confer114018683conf__er_
conferees14610623conferees
conferrers1546453conferrers
confess12399903conf__ess
confidant1547623confidant
confidants1644813confidants
confidence1847063confidence
confidences1946633confidences
confiding1638333confiding
configure1544463configure
configures1644213configures
confine12315583confine__
confined14310403confine_d
confirm1437363confi__rm
confirmer1665663confirmer_
confirms1536303confi_rms
confiteor1443873confiteor
confits122811423confi__ts
confiture1445953confiture
confitures1545603confitures
conformers1746553conformers
confounders1742923confounders
confrere1347563conf_rere
confreres1448033conf_reres
confuses13310363confuse_s
confuter1338513confuter_
confutes1339843confute_s
congeners122511133congeners
congers104223233con__gers
conies84338593con_i_e_s
conifer123212643con_ifer_
coniines10415363coniine_s
conines93827803con_ine_s
conjoiners1955403conjoiners
conjurers18126233conjurers
conkers133721043con__kers
conners94023113con__ners
conniver1337493conniver_
connivery1744213connivery
connives1339723connive_s
conoids10813883conoid__s
conquers1938223con_quers
considered1444283considered
consigners1346413consigners
consolers112510923consolers
conspirers1444573conspirers
consumers1337203consumers
containers1249903containers
contenders1348623contenders
continuers1247953continuers
contrivers1547253contrivers
conveners142911443conveners
conveyers17267203conveyers
convincers1745063convincers
convokers18246103convokers
copiers114215963co_pi_ers
corders104520883co__rders
corridors1245083corridors
cottiers10399163cotti_ers
couriers103213173couri_ers
cowhides1736013cowhide_s
cowriters14317293cowriters
donnikers1443443donnikers
infidels1244123_infidels
insiders947763_insiders
ionizers17257713ion_izers
joyriders2042233joyriders
lowriders1343183lowriders
monikers1437413mon_ikers
officers1643803_officers
ponders103618853pon__ders
reconsiders1443183reconsiders
sonders83820713son__ders
topsiders1243023topsiders
voiders11279823vo__iders
wonders113315993won__ders

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 Limit1486411327.17020731.0
3Display Results1321320.0632095.2
 (SQL Overall)1786911327.65623340.0
 
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.