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

141 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
infamy143565(None) 
infall939402infall
infancy1546172infancy
infant92315132infant
infare9313082infare
inflame1256962inflame
inlay85214322inla_y
angary10311323angary
anomy105113393an_omy
beamy126218573_beamy
bigamy1436343bigamy
binary11312223bin_ary
cinnamyl1541483cinnamyl
creamy134811363creamy
defame123212433defame
digamy1335893digamy
dreamy12509993dreamy
encamp1235943encamp
enemy1059993en_emy
enface112510353enface
enflame1236573enflame
enframe1247363enframe
fame95639393__fame
fay97454863__fa_y
flamy135217473_flamy
foamy135313203_foamy
fumy127118583__fumy
gamy105427533__gamy
gleamy12398113gleamy
iamb86623733i__amb
iffy135312283i_f_fy
ihram10310183ihram_
ihrams1137173ihrams
imam81718333i_mam_
imams91511113i_mams
immy114611833i__mmy
inane52820343in_ane
inapt73522693in_apt
inarm7314423in_arm
inarms8410093inarms
inby95315663in__by
incage93513623incage
incant82418503incant
incase83615283incase
income10712093income
incony1139083incony
indaba935633indaba
indamin1048043indamin
infalls1038943infalls
infamies1346683infamies
infamous1354543infamous
infanta10237253infanta
infante101910883infante
infantry1443853infantry
infants102210773infants
infarct1249013infarct
infares10313023infares
infauna1044403infauna
infect113413443infect
infer84215033inf_er
infers93615443infers
infest93315433infest
infill938413infill
infirm1137043infirm
infirmly1643083infirmly
infirms1245563infirms
infix15337773inf_ix
inflamed1446033inflamed
inflamer1356123inflamer
inflames1377323inflames
inflate10312313inflate
inflow1235293inflow
influx1643723influx
info75617353inf__o
infold10128163infold
inform11310153inform
informs1248073informs
infos84311673inf_os
infra838643inf_ra
infract12610003infract
infuse93110573infuse
ingate73018243ingate
inhale9411513inhale
inhaul936803inhaul
inhume1196583inhume
inia45024703inia__
injury16266143injury
inky115321583in__ky
inlace82513043inlace
inlaid7310143inlaid
inland7310313inland
inlays9389873inlays
inly75622213in__ly
inmate82917363inmate
innage73011573innage
innate63917313innate
insane6314883insane
inseam8329993inseam_
inseams9307903inseams
intact8314663intact
intake10510863intake
intima81910033intima
intime81014273intime
intomb1036403intomb
invade10157853invade
invar839513inva_r
invars9310003invars
inwall938343inwall
inward10310333inward
isogamy1343993isogamy
lingam95112353lingam_
lingams104510193lingams
loamy105913343_loamy
nam55953393_n_am_
name65637413_n_ame
nary76931223_n_ary
navy107518633_n_avy
nay66952773_n_a_y
nifty115211633nif_ty
nizam16310253nizam_
nizams1735413nizams
ofay106416103_ofa_y
onlay84212943onla_y
oogamy1235633oogamy
seamy105921273_seamy
snaky125113913sn_aky
sneaky13427843sneaky
steamy115112373steamy
swamy136714403_swamy
syngamy1643113syngamy
tiffany1642663tiffany
unary8315993un_ary
uneasy9278853uneasy
unfair936233unfair
unfancy1545203unfancy
unjam1448723unjam_
unjams1555703unjams
unlay84613703unla_y
unsay83212843unsa_y
untame82513603untame
unwary1239823unwary

Search took 6 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 Filter1786911127160.1401276364.3
2DLD Change Limit1127161415.58020200.0
3Display Results1411410.0463065.2
 (SQL Overall)1786911415.76630990.5
 
Comments and Suggestions welcome: FaceBook ~ UserVoice ~ SQLServerCentral  |  Developed By: Tom Keller Consulting © 2011-2024  |  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.