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

122 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
infirmed1420534(None) 
informed14197671informed
affirmed1743212affirmed
confirmed1745562confirmed
firmed125411882__firmed
inarmed10268672in_armed
inferred12248352inferred
infirm1137042infirm__
infirmly1643082infirmly
infirms1245562infirm_s
infixed18206562infi_xed
inflamed1446032inflamed
informer13227282informer
unfilmed1495802unfilmed
unfired112212452unfir_ed
unformed14239572unformed
affirmer1643083affirmer
antired82316193antir_ed
biformed1643693biformed
chirmed15379733_chirmed
confirmer1665663confirmer
conformed1767463conformed
deformed15248263deformed
enflamed1455723enflamed
enforced14216743enforced
enframed1466263enframed
engirded1143973engirded
farmed125117653__farmed
filmed124610363__filmed
fired94829743__fir_ed
firmer114712443__firmer
formed125021173__formed
inbred93010403in_br_ed
inbreed10267643in_breed
incised102911583inci_sed
incited103314623inci_ted
incurred1136493incurred
incurved1435313incurved
indicted1249203indicted
indited93515023indi_ted
indorsed1066123indorsed
infarcted1544243infarcted
infare9313083infar_e_
infares10313023infar_es
infected14229403infected
inferrer11217443inferrer
infested12249643infested
infidel1146043infi_del
infield1135823infi_eld
infirmary1752353infirmary
infirming1545163infirming
infirmity1743273infirmity
infixes17238133infi_xes
inflame1256963inflame_
inflamer1356123inflamer
inflames1377323inflames
inflated12410863inflated
inflexed1944013inflexed
inflicted1545533inflicted
infolded1375663infolded
inform11310153inform__
informal1355643informal
informedly1952793informedly
informers14206133informers
informs1248073inform_s
infrared1236193infrared
infringed1443833infringed
infused11329253inf_used
inhered11313163inher_ed
inhumed1375573in_humed
injured15339063injur_ed
innerved1246293innerved
inquired18245933inquir_ed
inserted92413053inserted
insisted998673insisted
inspired1136273inspir_ed
insured83714253insur_ed
interbed112413103interbed
interned93016653interned
interred92615263interred
intime81014273inti_me_
intitled967343intitled
intorted9310123intorted
inturned9268313inturned
inured73114813in_ur_ed
inurned8328053in_urned
inversed12269283inversed
inverted122312163inverted
invited113612463invi_ted
misfired14238543misfir_ed
misformed1745243misformed
nimmed11368573_n_immed
normed95014543_n_ormed
refilmed14235813refilmed
refired115116993refir_ed
reformed14249603reformed
reinformed1664333reinformed
squirmed2034173squirmed
unaimed102812493unai_med
unaired82916013unair_ed
unarmed101811923un_armed
undimmed1434113undimmed
unfilled1298383unfilled
unfished15218293unfished
unfitted1238163unfitted
unfixed18218563unfi_xed
unforced14239133unforced
unforged13238623unforged
unforked16218953unforked
unframed1478243unframed
unfreed11510123unf_reed
unfurled1277203unfurled
ungirded1136083ungirded
unharmed1438093unharmed
unhired112512153unhir_ed
uniformed1544533uniformed
uninformed1643653uninformed
unprimed1337203unprimed
unrimed102211633unri_med
untimed102713373unti_med
untired82316383untir_ed
unwarmed1437303unwarmed

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 Filter1786911461620.1731032896.0
2DLD Change Limit1461621227.07620656.0
3Display Results1221220.0462652.2
 (SQL Overall)1786911227.29524495.0
 
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.