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

211 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
condoner11291340(None) 
condoler113412111condoler
condone102616291condone_
condoned122612021condoned
condoners122811501condoners
condones112817391condones
commoner142710632commoner
condemner1445762condemner
condenser1287412condenser
condoes104319202condo_es
condole102914952condole_
condoled123110712condoled
condolers122710562condolers
condoles113015802condoles
condor94616962condo__r
condores113315632condores
conducer13127362conducer
confiner13311192confiner
congener112412202congener
conjoiner1855932conjoiner
conner84423962con__ner
consoler102812612consoler
convener132913162convener
convoker17226902convoker
cordoned12229612cordoned
coroner94218202co_roner
abandoner1242693abandoner
bonder95324783bond__er
candider1237343candider
candler103516593cand_ler
candor94516423cando__r
candour104210233cando_ur
canner84625983can__ner
cannoned11118133cannoned
cannoneer1143913cannoneer
canoer85121073can_o_er
cantoned111411523cantoned
canyoneer1443413canyoneer
canzone1858813canzone_
canzones1939153canzones
canzonet19410583canzonet
centner946853cen_tner
centones10313663centones
cinder94119123cind__er
cloner84418093c__loner
cocooned1337293cocooned
codder104416333co_d_der
coddler113710823co_ddler
coder86134213co_d__er
codger105814843co_d_ger
codon86522853co_don__
codons96119463co_don_s
coiner84323783co__iner
cojones163512103co_jones
colder95121833cold__er
colone85425003co_lone_
colonel94213283co_lonel
colones96124433co_lones
colorer9312523co_lorer
combiner14259723combiner
comedones1446933comedones
commoners15339783commoners
communer14349293communer
compone136517193compone_
composer145012953composer
conceder1338733conceder
concenter13312213concenter
conciser12310243conciser
concocter1247623concocter
condemned1545103condemned
condemners1546023condemners
condemnor1443593condemnor
condense1179613condense
condensed1387113condensed
condensers1386373condensers
condenses12710133condenses
conditioner1474663conditioner
condo85322593condo___
condolent1249833condolent
condom114215363condo__m
condoms124214083condo_ms
condoning1339783condoning
condors104018553condo_rs
condos94322333condo__s
conduce12139223conduce_
conduced14136953conduced
conducers14136553conducers
conduces13129773conduces
condylar1443643condylar
condyle13247053condyle_
condyles14277463condyles
confer114018683con__fer
confider1438123confider
confine12315583confine_
confined14310403confined
confiners1439953confiners
confines13315653confines
conformer1667463conformer
confounder1643493confounder
confronter1544363confronter
confuter1338503confuter
congeners122511133congeners
conger95024273con__ger
congoes103617303congo_es
conifer123212643con_ifer
coniine9316803coniine_
coniines10415363coniines
conine84528553con_ine_
conines93827793con_ines
conioses10313313conioses
conjoined1965463conjoined
conjoiners1955403conjoiners
conjurer17117673conjurer
conker124721553con__ker
conned95119703con__ned
conners94023113con__ners
conniver1337493conniver
connote9311613connote_
connoted1138863connoted
connotes10311453connotes
conodont11411153conodon_t
conodonts1246063conodonts
conquer1838613con_quer
consenter11312493consenter
consider11310393consider
consigner1246633consigner
console92715983console_
consoled112911443consoled
consolers112510923consolers
consoles103216153consoles
consumer1238503consumer
container11311073container
contemner1347183contemner
contender1239563contender
continuer1148713continuer
contour939963conto_ur
convene123314323convene_
convened143412223convened
conveners142911443conveners
convenes132916913convenes
convenor13307613convenor
conveyer16278143conveyer
convincer1645833convincer
convoke16207173convoke_
convoked18236163convoked
convokers18246103convokers
convokes17247703convokes
convoyed17225553convoyed
cooer74831013co__o_er
cooker124722453co__oker
cooler84824713co__oler
cooper104221123co__oper
cooter85128613co__oter
corder94322873cord__er
cordon95017293cordon__
cordonnet1246703cordonnet
cordons104415763cordon_s
corner84625623co__rner
cornpone1246933cornpone_
cornpones1347103cornpones
coronel94515223co_ronel
coroners104016223co_roners
coronet94227173co_ronet
cosigner1135953cosigner
cottoned1138033cottoned
cowinner1334753cowinner
cozener18328953co_zener
crayoner1344853crayoner
crooner93714043c_rooner
cunner83915003cun__ner
doggoner1143873doggoner
endower1138483_endower
fonder104120063fond__er
fondler11348883fond_ler
fordone1149373fordone_
goldener1045403goldener
gondolier1144723gondolier
handover15126823handover
holdover1544083holdover
honorer1039673hon_orer
intoner7811673_intoner
ionomer939833ion_omer
ionone6313443ion_one_
ionones7313883ion_ones
landowner1343663landowner
monomer11311893mon_omer
mooner85317833mo__oner
motioner1037593motioner
nondancer1245593nondancer
nonjoiner1665333nonjoiner
nonmoney1346273nonmoney
nonowner1145253nonowner
nonvoter1186893nonvoter
pardoner11189443pardoner
poisoner1046983poisoner
ponder94521693pond__er
ponderer112410193ponderer
pontonier1146383pontonier
sonder73623523sond__er
sooner64220463so__oner
sundowner1342793sundowner
tenoner739683ten_oner
tonner64819203ton__ner
undoer73113043_undo_er
undone7914253_undone_
wantoner1187563wantoner
wonder103617813wond__er
wonderer12249183wonderer
wonner95114443won__ner
woodener1245763woodener
yonder103214133yond__er

Search took 9 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.1701051123.5
2DLD Change Limit1461622118.58017035.2
3Display Results2112110.0932268.8
 (SQL Overall)1786912118.84320207.1
 
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.