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 “infarct” with Change Limit: [1] [2] [3] [4]

You can choose a higher Change Limit to return more words, although it will take longer.
to automatically increase the Change Limit after seconds.

90 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
infarct124901(None) 
infarcts1345231infarcts
infract12610001infract
inarch1139172in_arch
infancy1546172infancy
infant92315132infa_nt
infarcted1544242infarcted
infare9313082infar_e
infares10313022infares
infect113413442inf_ect
inflect1249222inflect
inflict1248622inflict
infracts1346622infracts
intact8314662inta_ct
anarch11310393an_arch
diffract1744723diffract
enact73525363en_a_ct
endarch1345443endarch
enface112510353enfa_ce
enforce12237423enforce
fact97142543__fa_ct
farce104925323__farce
farci105919313__farci
farcy135217093__farcy
fart76860563__far_t
imaret81121233i_maret
impact122310453impa_ct
impart102715143impar_t
inapt73522693in_a_pt
inarm7314423in_ar_m
inarms8410093in_arms
inburst937163inburst
incant82418513inca_nt
indict93115573in_dict
indirect1147523indirect
indraft1199573indraft
induct93212743in_duct
inearth1037043inearth
inert53234373in_er_t
inexact1647413inexact
infall939403infa_ll
infalls1038943infalls
infamy1435653infa_my
infanta10237253infanta
infante101910883infante
infants102210773infants
infarction1545793infarction
infauna1044403infauna
infects12279713inf_ects
infer84215033infer__
inferno1045603inferno
infers93615443infer_s
infest93315433inf_est
infight1437453infight
infirm1137043infir_m
infirms1245563infirms
inflects1336193inflects
inflicts1345613inflicts
inform11310153infor_m
informs1248073informs
infra838643inf_r_a
infracted1546363infracted
infractor1465943infractor
infrared1236193infrared
ingraft1199503ingraft
inhabit1277403inhabit
inherit10312973inherit
inject153210233in_ject
inlace82513043inla_ce
innards837153innards
insect83916583in_sect
insert64325253inser_t
inspect1138463inspect
instruct1047543instruct
interact10316473interact
intercut10411113intercut
intort6418923intor_t
intrant7318753intrant
invar839513invar__
invars9310003invar_s
invert94120083inver_t
inward10310333inwar_d
inwards1138343inwards
minaret9520683min_aret
narc67127953_n_arc_
narco76718243_n_arco
narcs76122023_n_arcs
nonfact1248893nonfa_ct
refract121311603refract
unfancy1545203unfancy

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 Filter1786911340270.406440125.6
2DLD Change Limit134027906.54620474.6
3Display Results90900.0332727.3
 (SQL Overall)178691906.98525582.1
 
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.