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

(Found more than 100 similar words, so Change Limit cannot be increased.)
to automatically search another random word after seconds.

120 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
infer8421503(None) 
infers93615441infers
inker94421091inker
inner54920631inner
inter55028491inter
anger66225872anger
binder94422872binder
biner75930692bin_er
binger94923452binger
cinder94119122cinder
coinfer12419392coinfer
confer114018682confer
defer94619752defer
differ133910842differ
diner65632902din_er
dinger85323672dinger
dinner74217162dinner
ender64325862ender
enter54726382enter
fer66646122__fer
fifer115519972fifer
finder104020232finder
finer85431562fin_er
finger104920332finger
ginger84920032ginger
ginner73915822ginner
gofer94814282gofer
hinder104120062hinder
hinger104723332hinger
hinter94021302hinter
icier74313752icier
icker114018442icker
idler65015662idler
iffier1236762iffier
iller54821292iller
inaner62213542inaner
incher114114032incher
incur72212252incur
index13310982index
inert53234372in_ert
infare9313082infare
infect113413442infect
inferno1045602inferno
infest93315432infest
infirm1137042infirm
infix15337772infix
info75617352inf_o
inform11310152inform
infos84311672infos
infra838642infra
infuser10298322infuser
inhere9313712inhere
inked104218522inked
inkers104018832inkers
inkier104013782inkier
inlet53732402inlet
inlier63615362inlier
inned64118422inned
inners63919352inners
insert64325252insert
inset54430862inset
intern64016542intern
inters64328052inters
inure54119052inure
invar839512invar
invert94120082invert
ither84617602ither
jinker174013542jinker
kinder113716842kinder
knifer13598562knifer
liefer9529572liefer
lifer85822152lifer
liner55938922lin_er
linger75226002linger
linier64423792linier
linker104321472linker
linter64625342linter
mincer104017362mincer
minder94822502minder
miner76933542min_er
minter84425102minter
nicer74618292nicer
niffer12378442niffer
niter55028972niter
offer114311382offer
pilfer1139162pilfer
pincer104019172pincer
pinder94523452pinder
pinger94324092pinger
pinier84024692pinier
pinker125322442pinker
pinner84521502pinner
refer84822142refer
rifer84721982rifer
ringer74526062ringer
rinser64317212rinser
safer84721812safer
singer74227312singer
sinker103620902sinker
sinner64320602sinner
sinter63625922sinter
sneer54919952sneer
tinder73821802tinder
tinier63622232tinier
tinker103619922tinker
tinner64119962tinner
tinter63923642tinter
titfer9409522titfer
under64624212under
unfed94614222unfed
vinier93716742vinier
wafer114417642wafer
wincer115018192wincer
winder104025262winder
winger104125442winger
winier94522452winier
winker134220292winker
winner94219932winner
winter94222802winter
zinger163816702zinger

Search took 3 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 Filter178691538000.313570897.8
2DLD Change Limit538001201.72031279.1
3Display Results1201200.0304000.0
 (SQL Overall)1786911202.06386617.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.