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

153 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
condolers12271056(None) 
condoler113412111condoler_
condoles113015801condole_s
condoners122811491condoners
consolers112510921consolers
candlers114214102cand_lers
coddlers12359162co_ddlers
condoes104319202condo_e_s
condole102914952condole__
condoled123110712condole_d
condolent1249832condolent
condoner112913392condoner_
condones112817392condone_s
condores113315632condore_s
condors104018552condo__rs
conducers14136552conducers
condyles14277462condyle_s
consoler102812612consoler_
consoles103216152console_s
convokers18246102convokers
coolers93522492co__olers
fondlers12338022fond_lers
gondoliers1243692gondoliers
bandoleers1343563bandoleers
bandoliers1344143bandoliers
bonders104120663bond__ers
bondholders1852833bondholders
bondless1148813bond_less
boodlers113710743bood_lers
bundlers11399183bund_lers
cajolers17267133c_ajolers
canallers1137213canallers
cancelers13247863cancelers
candler103516593cand_ler_
candles104422343cand_le_s
candors104216763cando__rs
candours11408613cando_urs
canoers94318373can_o_ers
carolers103314173c_arolers
chandlers15387673chand_lers
cholers124215193c__holers
cinders104617753cind__ers
cineoles10109403cineole_s
coalers94419333co__alers
cobblers14359593co_bblers
codders114114443co_d_ders
coddler113710823co_ddler_
coddles114213593co_ddle_s
codeless112010113co_deless
coders95426973co_d__ers
codgers115113923co_d_gers
coholders1535613co_holders
coilers93619903co__ilers
colorers10312183co_lorers
commoners15339783commoners
compilers1537053compilers
composers153910613composers
concealers1476913concealers
conceders1437953conceders
concocters1346753concocters
concours1239433conco_urs
condemners1546023condemners
condensers1386373condensers
condolence1565303condolence
condolences1655283condolences
condoling13510373condoling
condoms124214083condo__ms
condone102616293condone__
condoned122612023condone_d
condor94616963condo__r_
condos94322333condo___s
conducer13127363conducer_
conduces13129773conduce_s
condylar1443643condylar_
condyle13247053condyle__
confers124120093con__fers
confiders1537483confiders
confiners1439953confiners
conformers1746553conformers
confuters1437773confuters
congealers1365663congealers
congeners122511123congeners
congers104223233con__gers
congoes103617303congo_e_s
conifers133611703con_ifers
conioses10313313coniose_s
conjoiners1955403conjoiners
conjurers18126223conjurers
conkers133721043con__kers
conners94023113con__ners
connivers1436933connivers
connotes10311453connote_s
conquers1938213con_quers
considers1238933considers
console92715983console__
consoled112911443console_d
consols92914073consol__s
consulters1297203consulters
consumers1337203consumers
contours1039613conto_urs
controllers1344783controllers
conveners142911443conveners
conveyers17267203conveyers
convoker17226903convoker_
convokes17247703convoke_s
convolves1745323convolves
cooers84324563co__o_ers
cookers134619463co__okers
cooler84824713co__oler_
coopers114019483co__opers
cooters94525713co__oters
corders104520873cord__ers
cordless11299963cord_less
coroners104016223co_roners
corulers1039763co_rulers
couplers123311313co_uplers
cradlers11309183crad_lers
cuddlers12388383c_uddlers
curdlers11368493curd_lers
dandlers103912053dand_lers
doodlers10338843dood_lers
endowers1238233_endowers
fondler11348883fond_ler_
fondles113512613fond_le_s
gondolas1046193gondol_as
gondolier1144723gondolier_
handlers124014143hand_lers
handovers16136183handovers
holdovers1643763holdovers
hondles113614523hond_le_s
honorers1139263hon_orers
indoles83716363_indole_s
ionomers1038503ion_omers
kindlers13318483kind_lers
landlers94312833land_lers
modelers1138463mo_delers
monomers12311033mon_omers
noncolors1147033noncolors
nongolfers1443383nongolfers
nonvoters12136463nonvoters
ponderers12248443ponderers
ponders103618843pond__ers
poolers94217423po__olers
rondelets1045263rondelets
sonders83820713sond__ers
toddlers10346953to_ddlers
toolers74416503to__olers
undoers82910573_undo_ers
wonderers13217933wonderers
wonders113315993wond__ers
woolers104214023wo__olers
yodelers1235673yo_delers
yodlers11298923yo_d_lers

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 Filter1786911486410.1531167915.0
2DLD Change Limit1486411538.83016833.6
3Display Results1531530.0801912.5
 (SQL Overall)1786911539.06319716.5
 
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.