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

214 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
condoned12261202(None) 
condoled123110711condoled
condone102616291condone_
condoner112913411condoner
condones112817391condones
cordoned12229611cordoned
cannoned11118132cannoned
cantoned111411522cantoned
cocooned1337292cocooned
condemned1545102condemned
condensed1387112condensed
condoes104319202condo_es
condole102914952condole_
condoler113412122condoler
condoles113015802condoles
condoners122811512condoners
condores113315642condores
conduced14136962conduced
confined14310402confined
conjoined1965462conjoined
conned95119702con__ned
connoted1138862connoted
consoled112911442consoled
convened143412222convened
convoked18236162convoked
convoyed17225552convoyed
cottoned1138032cottoned
abandoned1342723abandoned
blondined1343483blondined
bonded104719953bond__ed
candied113816023cand_ied
candled113815733cand_led
canned95022063can__ned
canoed94618953can_o_ed
canzone1858813canzone_
canzones1939153canzones
canzonet19410583canzonet
cartoned111312833cartoned
censored11197953censored
centones10313663centones
cindered1239793cindered
cloned94518803c__loned
codded114515303co_d_ded
coddled123410573co_ddled
coded95433183co_d__ed
codon86522853co_don__
codons96119463co_don_s
coedited1237833coedited
coendured1344093coendured
coffined1735993coffined
coigned11418663co_igned
coined94523603co__ined
cojoined1856293cojoined
cojones163512103co_jones
cologned1237153cologned
colone85425003co_lone_
colonel94213283co_lonel
colones96124433co_lones
colored10313473co_lored
columned1334923columned
combined15269183combined
comedones1446933comedones
commoner142710633commoner
commoved1844763commoved
communed15338213communed
compone136517193compone_
composed154612063composed
concaved1636223concaved
conceded1438283conceded
concerned1438643concerned
concocted1346763concocted
concord12510343conco_rd
condemner1445763condemner
condense1179613condense
condenser1287413condenser
condenses12710133condenses
conditioned1564283conditioned
condo85322593condo___
condolent1249833condolent
condolers122710573condolers
condom114215363condo__m
condoms124214083condo_ms
condoning1339783condoning
condor94616973condo__r
condors104018573condo_rs
condos94322333condo__s
conduce12139233conduce_
conducer13127373conducer
conduces13129783conduces
conducted1547313conducted
condyle13247053condyle_
condyles14277463condyles
coned86040053c___oned
confided1537453confided
confine12315583confine_
confiner13311193confiner
confines13315653confines
conformed1767463conformed
confound1445903confound
confounded1743293confounded
confronted1644193confronted
confused1437033confused
confuted1437683confuted
congaed11399743con_gaed
congeed113212313con_geed
congener112412203congener
conglobed1543293conglobed
congoes103617303congo_es
coniine9316803coniine_
coniines10415363coniines
conine84528553con_ine_
conines93827793con_ines
conioses10313313conioses
conjoiner1855933conjoiner
conjured18117903conjured
conked135019113con__ked
conner84423963con__ner
connived1436433connived
connote9311613connote_
connotes10311453connotes
conodont11411153conodon_t
conodonts1246063conodonts
conoid9818883con_o_id
consented12311943consented
consigned1346323consigned
console92715983console_
consoler102812613consoler
consoles103216153consoles
consorted1239773consorted
consumed1337923consumed
contained12310893contained
contemned1446793contemned
contend103511893conten_d
contended1339273contended
contented12313043contented
continued1248483continued
contorted1239473contorted
contoured1237303contoured
contused1138443contused
convene123314323convene_
convener132913163convener
convenes132916913convenes
convented15410753convented
conveyed17247923conveyed
convinced1745363convinced
convoke16207173convoke_
convoker17226903convoker
convokes17247703convokes
convolved1844083convolved
cooed84534343co__o_ed
cooeed95917863co__oeed
cooked135921363co__oked
cooled95224583co__oled
cooped114821603co__oped
corded105923353cord__ed
cordon95017293cordon__
cordonnet1246703cordonnet
cordons104415763cordon_s
corned95224523co__rned
cornpone1246933cornpone_
cornpones1347113cornpones
cornrowed1543623cornrowed
coronel94515223co_ronel
coroner94218203co_roner
coronet94227173co_ronet
corroded12147513corroded
cosigned1235723cosigned
cowboyed1943373cowboyed
cozened19349183co_zened
crayoned1435003crayoned
crooned103813343c_rooned
doggoned1243883doggoned
donned85015743don__ned
downzoned23132953downzoned
endowed1248173_endowed
fonded115717043fond__ed
fondled12399423fond_led
fondued12466363fond_ued
fordone1149383fordone_
hoidened1335653hoidened
hondled123510653hond_led
honored11310123hon_ored
hoodooed1344963hoodooed
hoydened1644643hoydened
indowed1237443_indowed
intoned8811993_intoned
ionone6313443ion_one_
ionones7313883ion_ones
loudened1044693loudened
mooned94216643mo__oned
motioned1137453motioned
neoned7311483__neoned
nonbonded1344293nonbonded
nonmoney1346273nonmoney
odored8399223_o_dored
pardoned12189333pardoned
pennoned1136313pennoned
pinioned1137513pinioned
poisoned1136953poisoned
ponded105218773pond__ed
pondered126411293pondered
pondweed1543103pondweed
soddened1144643soddened
sundowned1442683sundowned
tenoned839363ten_oned
unboned103014223_unboned
undone7914253_undone_
unzoned172310653_unzoned
voodooed1343293voodooed
wantoned12117223wantoned
windowed1635573windowed
wondered13239943wondered
wonned104012063won__ned
zooned164011083zo__oned

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 Filter1786911461620.313570897.8
2DLD Change Limit1461622148.65616885.6
3Display Results2142140.1101945.5
 (SQL Overall)1786912149.07919681.8
 
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.