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

163 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
instant781535(None) 
instants8910151instants
constant10515592constant
distant83519952distant
incant82418512in_cant
incitant10810082incitant
infant92315132in_fant
infestant1247232infestant
inkstand1343802inkstand
insane6314892ins_ane
inspan837512inspan_
inspans937802inspans
instal6712192insta_l
install779362install
instals7611712instals
instance1049882instance
instancy1346572instancy
instanter946242instanter
instantly1256012instantly
instar6310012insta_r
instars7411132instars
instate71616482instate
instinct1048722instinct
insulant849882insulant
insurant8411432insurant
intact8314662in_tact
intent63122772in_tent
intrant7318752intrant
issuant748262issuant
natant6318732_natant
nutant6316382_nutant
askant10412713_askant
aslant6317753_aslant
blatant9310673blatant
castanet10416193castanet
constants11410913constants
descant104315593descant
dilatant948203dilatant
discant103017263discant
distent84120853distent
enchant12313133enchant
entrant7318873entrant
extant132714753_extant
gestalt8411173gestalt
hesitant1149083hesitant
ignorant947153ignorant
implant11311333implant
inane52820343in__ane
inapt73522693in__apt
incants92012803in_cants
incent83320723in_cent
incessant1146103incessant
incitants1196193incitants
inconstant1256193inconstant
indent73021243in_dent
indicant11410343indicant
indraft1199573indraft
inerrant8412493inerrant
inexact1647413inexact
infanta10237253in_fanta
infante101910883in_fante
infants102210773in_fants
infectant1446833infectant
infestants1344503infestants
infract12610003infract
ingraft1199503ingraft
inhalant1147403inhalant
injectant1845293injectant
inkstands1443193inkstands
inkstone1245413inkstone
inland7310313in_land
insaner7310443ins_aner
insanest8410343ins_anest
insanity1147343ins_anity
inscape1138023inscape
inseam8329993insea_m
inseams9307903inseams
insect83916583ins_ect
insectan1045393insectan_
insert64325253ins_ert
inset54430863ins__et
insight1137913insight
insigne837673insigne
insist6314513ins_ist
insistent948253insistent
insnare748243insnare
insolent81311553insolent
inspect1138463inspect
instable10313203instable
installs858923installs
instalment1245383instalment
instanced1245703instanced
instances1148753instances
instated91613343instated
instates81615833instates
instating10812213instating
instead836203instead
instep838193inst_ep
insteps936573insteps
instil61111383inst_il
instill789063instill
instils7811453instils
instincts1144533instincts
instruct1047543instruct
insulants946913insulants
insult62813673ins_ult
insurants947653insurants
inswept1245733inswept
intake10510863in_take
intend72310373in_tend
intents72115703in_tents
intine61021983in_tine
intone61115433in_tone
intort6418923in_tort
intranet8418443intranet
intrants8312863intrants
intuit6314083in_tuit
inundant945783inundant
invent93316363in_vent
irritant847693irritant
island738533i_sland
iterant7317783iterant
jessant1438443jessant
kinsman1335963kinsman_
linsang835863lins_ang
militant10411403militant
ministrant1255813ministrant
misstart10410043misstart
mustang10267933mustang
mutant8317693_mutant
octant81216553_octant
onstage838363onstage
passant9813943passant
pintano998993pin_tano
pissant91012503pissant
reptant92817073reptant
restart7320033restart
saltant7316773saltant
scant79735073__scant
sextant142911963sextant
slant55238703__slant
stand65923283__stand
stane55933003__stane
stang66424693__stang
stank95823303__stank
start55642313__start
stat47352693__sta_t
statant7313123statant
stent55634513__stent
stint57037663__stint
stunt55328173__stunt
tinstone848173tinstone
unmeant9510903unmeant
unseat64221023unsea_t
unsent63820963uns_ent
unsmart939603unsmart
unspent92610893unspent
unstack1337373unstack
unstate71916213unstate
unstung834853unstung
upstand1045343upstand
upstart9159753upstart
visitant1147363visitant

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 Limit1340271635.84322938.0
3Display Results1631630.0632587.3
 (SQL Overall)1786911636.31228309.7
 
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.