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

155 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
informed1419767(None) 
infirmed14205341infirmed
informer13227281informer
unformed14239571unformed
biformed1643692biformed
conformed1767462conformed
deformed15248262deformed
enforced14216742enforced
formed125021172__formed
inarmed10268672in_armed
indorsed1066122indorsed
inferred12248352inferred
inflamed1446032inflamed
infolded1375662infolded
inform11310152inform__
informal1355642informal
informedly1952792informedly
informers14206132informers
informs1248072inform_s
intorted9310122intorted
misformed1745242misformed
normed95014542_n_ormed
reformed14249602reformed
reinformed1664332reinformed
unforced14239132unforced
unforged13238622unforged
unforked16218952unforked
uniformed1544532uniformed
uninformed1643652uninformed
affirmed1743213affirmed
afforded1643433afforded
ausformed1542323ausformed
bewormed16235443bewormed
biforked1842873biforked
confirmed1745563confirmed
conformer1667463conformer
defoamed15356243defoamed
deforced15247373deforced
deformer14247943deformer
dewormed15236223dewormed
disinformed1853013disinformed
encored10412103encor_ed
endorsed1057193endorsed
enflamed1455723enflamed
enfolded1345433enfolded
enforce12237423enforce_
enforcer13246503enforcer
enforces13208013enforces
enframed1466263enframed
engorged1134553engorged
farmed125117653__farmed
firmed125411883__firmed
foamed126014403__foamed
forced126316523__forced
forded115020393__forded
forged115519323__forged
forked145217143__forked
forme105225993__forme_
formee113919943__formee
former114221403__former
formes114623713__formes
gormed105013833__gormed
ignored9226443ignor_ed
imported13308693imported
inbred93010403in_br_ed
inbreed10267643in_breed
income10712093inco_me_
incomer1169943inco_mer
incomes11712373inco_mes
incorpsed1443883incorpsed
incurred1136493incurred
incurved1435313incurved
indorse8108193indorse_
indorsee977443indorsee
indorser985713indorser
indorses968063indorses
indowed1237443indo_wed
infarcted1544243infarcted
infare9313083infar_e_
infares10313023infar_es
infected14229403infected
infeoffed1541283infeoffed
inferrer11217443inferrer
infested12249643infested
infirm1137043infirm__
infirmly1643083infirmly
infirms1245563infirm_s
infixed18206563inf_ixed
inflame1256963inflame_
inflamer1356123inflamer
inflames1377323inflames
inflated12410863inflated
inflexed1944023inflexed
infold10128163info__ld
infolder1256433infolder
informant1446473informant
informing1537023informing
infrared1236193infrared
infused11329253inf_used
ingoted939183ingo_ted
inhered11313163inher_ed
inhumed1375573in_humed
injured15339063injur_ed
innerved1246293innerved
inpoured1135813inpoured
inserted92413053inserted
insouled936113insouled
insured83714253insur_ed
interbed112413103interbed
interned93016653interned
interred92615263interred
intombed1363733intombed
intoned8811993into_ned
inturned9268313inturned
inured73114813in_ur_ed
inurned8328053in_urned
inversed12269283inversed
inverted122312163inverted
invoiced1494823invoiced
invoked1535303invo_ked
involved1534343involved
malformed1742373malformed
minored10310103min_or_ed
misinformed1952323misinformed
performed17155303performed
pinafored1543223pinafor_ed
pinfolded1643333pinfolded
preformed17176203preformed
preinformed1952663preinformed
reforged13268703reforged
reformer13217953reformer
reinforced1664123reinforced
slipformed1861723slipformed
snored74819543sn_or_ed
snorted83813493sn_orted
stormed1039043_stormed
triformed1543733triformed
unarmed101811923un_armed
uncorked152210403uncorked
undeformed1743373undeformed
unfilmed1495803unfilmed
unfired112212453unfir_ed
unfoiled12249723unfoiled
unfolded1338313unfolded
unframed1478243unframed
unfreed11510123unf_reed
unfurled1277203unfurled
unharmed1438093unharmed
unhorsed1238833unhorsed
uniformer1443633uniformer
unreformed1643563unreformed
unsorted9312513unsorted
unwarmed1437303unwarmed
unworked16238503unworked
wormed124314303__wormed

Search took 7 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.406440125.6
2DLD Change Limit1461621556.17323677.6
3Display Results1551550.0632460.3
 (SQL Overall)1786911556.64226903.2
 
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.