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

104 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
coinhered153659(None) 
coinhere1337131coinhere_
coinheres1447631coinheres
cindered1239792c_indered
ciphered1637052c_iphered
clinkered1634772clinkered
cohered133514692co__hered
coinferred1643892coinferred
coinsured1245512coinsured
cointerred1346552cointerred
cornered11311132corn_ered
coshered14610292co_shered
countered12313002countered
inhered11313162__inhered
blinkered1644413blinkered
blithered15156123blithered
bothered142110393bo_thered
cancered132411553c_ancered
cankered153010223c_ankered
cantered113415983c_antered
centered112513523c_entered
chippered1945003chippered
chittered15166413chittered
chuntered1536663chuntered
cipherer1545573c_ipherer
cloistered1344513cloistered
coanchored1843273coanchored
coannexed1942953coannexed
cockered17710213co_ckered
coendured1344093coendured
coffered1737673co_ffered
cohere112716993co__here_
coherer122912783co__herer
coheres122917693co__heres
coiffured1842613coiffured
coincided1544023coincided
coined94523603coin___ed
coiner84323783coin_er__
coiners93620753coin_er_s
coinfected1843823coinfected
coinfer12419393coinfer__
coinfers13349503coinfer_s
coinhering1647313coinhering
coinsure1046933coinsure_
coinsurer1144773coinsurer
coinsures1136723coinsures
cointer93616723cointer__
cointers103616413cointer_s
coinvented1643993coinvented
compeered1646303compeered
compered153414923co_mpered
conceded1438293co_nceded
concerned1438643co_ncerned
concerted14312113co_ncerted
conferee13613733co_nferee
conferred1537753co_nferred
congeed113212313co_nge_ed
conjured18117903co_njured
conquered2145463conquered
conserved1538853co_nserved
convened143412223co_nvened
converged1636973co_nverged
conversed1538683co_nversed
converted15311563co_nverted
conveyed17247923co_nveyed
coopered133310933co_opered
coppered153410543co_ppered
cottered112511733co_ttered
counseled1245053counseled
covered133315293co__vered
cowered133214653co__wered
cowherd1636953co_wher_d
cylindered1742063cylindered
cyphered1934653c_yphered
dithered13189293_dithered
domineered1442523domineered
donnered10307753do_nnered
fingered13128333_fingered
foundered1435403foundered
gingered11127743_gingered
hindered1339453_hindered
inhere9313713__inhere_
inheres10315173__inheres
jointured17133483jointured
koshered1636063ko_shered
lingered10129643_lingered
loitered938183loi_tered
mongered1238953mo_ngered
mothered142310103mo_thered
ochered132610283_o_chered
pioneered1253733pioneered
pondered126411293po_ndered
pothered142311043po_thered
roistered1037643roistered
scouthered1643643scouthered
sintered92213903_sintered
slithered13136623slithered
swithered16135463swithered
tinkered1387683_tinkered
tochered1437913to_chered
vouchered1843853vouchered
wintered122111573_wintered
withered15169433_withered
wondered13239943wo_ndered

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.420425454.8
2DLD Change Limit1486411046.86021667.8
3Display Results1041040.0462260.9
 (SQL Overall)1786911047.32624391.3
 
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.