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

307 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
inanest7211536(None) 
inanes62519801inanes_
insanest8410341insanest
anapest9311552anapest
inane52820342inane__
inanely1037942inanely
inaner62213542inane_r
incest82918742in_cest
infest93315432in_fest
ingest73119002in_gest
inkiest113415042inkiest
inquest1638602inquest
invest93014842in_vest
iratest7312482iratest
leanest7415862leanest
meanest9315702meanest
onanist7314632onanist
sanest64426692_sanest
tannest72617852tannest
wannest103915002wannest
analyst10189323analyst
anankes1138763anankes_
anapaest1046023anapaest
anapests1046613anapests
anenst63514983__anenst
anent54931843__anent
anes45255933__anes_
angst6415493__angst
banes74945583_banes_
bannet84925333banne_t
bannets94013843bannets
barest85327693_barest
basest84720493_basest
blandest113811043blandest
blankest14439063blankest
bravest124211753bravest
brawest123810483brawest
canes75350373_canes_
canniest10313363canniest
canst74932213_can_st
cleanest10310293cleanest
cranes84330753cranes_
crankest1438143crankest
dankest122611673dankest
deadest93014883deadest
deafest112911513deafest
dearest83618673dearest
dingiest102915373dingiest
dinkiest133812873dinkiest
divinest123012173divinest
dunnest83312263dunnest
earnest7318733earnest
enates64026433enates_
evenest10312103evenest
fainest10417703fainest
fanes84639893_fanes_
featest102715113featest
finales104016013finales_
finalist113014733finalist
finances1338653finances_
fineness11310643fineness
finest94321733_finest
finniest113011403finniest
flanes94522423flanes_
frankest1536963frankest
funest94316863_funest
funnest102912003funnest
gamest94919933_gamest
gannet74321853ganne_t
gannets83811443gannets
gayest104314333_gayest
ginniest92610513ginniest
grandest10311573grandest
gravest114011633gravest
grayest11489363grayest
halest94823273_halest
hangnest12311413hangnest
hinkiest153311753hinkiest
honest94822423_honest
humanest1348123humanest
iciest82914743i_ciest
iciness938863iciness
ickiest133611043ickiest
icones84616383icones_
idlest74014863i_dlest
iffiest1337963iffiest
illest63615723i_llest
illness736473illness
images91411463images_
imagist1077333imagist
imaret81121233imare_t
imarets9138643imarets
imines84918353imines_
immanent1246803immanent
imprest11310203imprest
inaneness948383inaneness
inanity1039503inanity
inapt73522693ina__pt
inaptness1144333inaptness
inarms8410093inarms_
inburst937163inburst
incages103013883incages_
incant82418513incan__t
incants92012803incants_
incases93615973incases_
incense92410303incense
incent83320723in_cent
incents92414533incents
incept102712753in_cept
incests92711383in_cests
inches114419673inches_
incrust949203incrust
indenes82916253indenes_
indent73021243in_dent
indents83114663indents
indies73822783indies_
indues73515263indues_
indwelt1146513indwelt
inept73622153i__nept
inert53234373i__nert
infant92315133infan__t
infantes11249633infantes_
infants102210773infants_
infares10313023infares_
infect113413443in_fect
infests10279793in_fests
inflect1249223inflect
ingates82716913ingates_
ingesta8357863in_gesta
ingests83210983in_gests
ingles74420873ingles_
ingress838653ingress
inhales10511863inhales_
inject153210233in_ject
inkiness1238693inkiness
inkjet1737453inkje_t
inkles103515653inkles_
inkless11348713inkless
inlaces92512903inlaces_
inlands838783inlands_
inlet53732403in_le_t
inlets63915573in_lets
inmates92715783inmates_
inmesh1134863in_mesh
inmost8411363in_most
innages82911303innages_
inned64118423in_ne_d
inner54920633in_ne_r
inners63919353in_ners
innless7288293innless
inns46920933in_n_s_
inquests1744943inquests
insane6314893insane__
insanely1146123insanely
insaner7310443insane_r
insect83916583in_sect
insert64325253in_sert
inset54430863in_se_t
insets64016133in_sets
insist6314513in_sist
inspect1138463inspect
inswept1245733inswept
intakes11310943intakes_
intense72511903intense
intensest949103intensest
intent63122773in_tent
intents72115703intents
interest8319183interest
intines7921113intines_
intones7816543intones_
intranet8418443intrane_t
intranets949263intranets
intreat7416303intreat
intrust7311493intrust
intwist1038043intwist
inures63318953inures_
invades11118293invades_
invent93316363in_vent
invents102812053invents
invert94120083in_vert
invests10319683in_vests
ionones7313883ionones_
irades74517393irades_
irones64724013irones_
ironist7314843ironist
janes124928123_janes_
jnanas13207303jnanas_
kanes95529373_kanes_
keenest11410963keenest
kinases113511123kinases_
kindest12311503kin_dest
kindness13236653kindness
kinkiest113110503kinkiest
knaves13439523knaves_
knawes13328393knawes_
lamest84722763_lamest
lanes54946793_lanes_
lankest112714113lankest
latest63822703_latest
laxest134913363_laxest
lianes63819323lianes_
linages8813173linages_
lindanes939173lindanes_
lingiest93715263lingiest
liniest73321153lin_iest
linnet6419423lin_ne_t
linnets739833lin_nets
lintiest82715913lintiest
manes76648963_manes_
mayest114614793_mayest
minaret9520683minare_t
minarets1048843minarets
minciest122913113minciest
mingiest113315823mingiest
mintiest103217143mintiest
minutest10247653minutest
nabes75427093_nabes_
naivest10309473_naivest
names74833363_names_
nanas55928633_nanas_
nances83618643_nances_
nanism8311203_nanism
nans46139403_nan_s_
napes74828463_napes_
nares55544153_nares_
nates55238333_nates_
naves87030383_naves_
nearest73415843nearest
neatest72516003neatest
nenes55329673_nenes_
nest45548733___nest
newest9314213_newest
nicest82315663_nicest
nighest11310693nighest
nines55937343_nines_
nones55639133_nones_
nonet54540843_none_t
nonets64118703_nonets
nudest74113833_nudest
onanism9310133onanism
onanists838413onanists
oneness7512143oneness
openest9312913openest
palest83926223_palest
panes76148693_panes_
pannes85522853pannes_
pianist9615103pianist
pinangs10267793pinangs_
pinenes93416673pinenes_
piniest93121133pin_iest
pinkest132812623pin_kest
pinkness1436513pinkness
pinones94717073pinones_
plainest10313613plainest
planes85028083planes_
planet84228353plane_t
planets93914083planets
rankest112713813rankest
rarest65725483_rarest
rawest93615063_rawest
realest73322433realest
renest64529713_renest
safest95016603_safest
sagest74920263_sagest
sanes55649073_sanes_
sayest94217743_sayest
scantest101710183scantest
searest73322023searest
silanes72517163silanes_
snakes103919603snakes_
snakiest122110543snakiest
snares65329033snares_
snidest8310913snidest
soonest7415593soonest
sparest94616423sparest
stalest73720173stalest
stanes64933403stanes_
suavest10310623suavest
swankest15105933swankest
tamest85721293_tamest
tanist6324593_tanist
thanes94918983thanes_
thinnest11248893thin_nest
tiniest73020123tin_iest
tininess8310633tininess
tinniest82911463tinniest
tisanes7311853tisanes_
titaness836723titaness
trapnest10310923trapnest
unadept1046603unadept
unblest9411813unblest
undrest8313013undrest
unrest62918853un_rest
urbanest10117533urbanest
vainest10315763vainest
vanes85130973_vanes_
viniest103216613vin_iest
wanes85040883_wanes_
waniest103819113waniest
wanness102610683wanness
weakest1439003weakest
windiest122213233windiest
wingiest123214283wingiest
winiest103419693win_iest
yarest95018913_yarest
zaniest163214773zaniest
zingiest182810893zingiest

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 Filter1786911340270.406440125.6
2DLD Change Limit1340273076.64020184.8
3Display Results3073070.1232495.9
 (SQL Overall)1786913077.16924925.5
 
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.