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

226 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
instals761171(None) 
instal6712191instal_
install779361install
installs858921installs
instars7411131instars
instils7811451instils
initials848102initials
inseams9307902inseams
insouls737212insouls
inspans937802inspans
instable10313202instable
instant7815342instant
instants8910152instants
instar6310012insta_r
instate71616482instate
instates81615832instates
insteps936572insteps
instil61111382instil_
instill789062instill
instills867352instills
postals93716372postals
unseals73212572unseals
vestals104612332vestals
acetals93411353acetals
ainsells895403ainsells
animals94111703animals
annals66415923an_nals
anneals7449943anneals
annuals7388193annuals
antas55432033an_ta_s
astrals75515243_astrals
australs8359533australs
bimetals1246943bimetals
borstals1037463borstals
buttals938503buttals
cantals93919573cantals
casuals91410523casuals
centals94317053centals
cestas85018543cesta_s
costal85419513costal_
costars94218013costars
crystals1347173crystals
curtals93111623curtals
dentals83915393dentals
digitals1045433digitals
dismals102010243dismals
distal73615773distal_
distils83015803distils
dossals8379293dossals
ensnarls873393ensnarls
ensouls736033ensouls
entails7912823en_tails
festal94213563festal_
fiestas1038433fiesta_s
finals94316163fin__als
finials103210153fin_ials
fiscals1238003fiscals
genitals937243genitals
gestalt8411163gestalt
gestalts955493gestalts
gingals9109313gin_gals
hartals10313023hartals
hostas94515823hosta_s
hostels103712313hostels
ideals75012503i_deals
indols74714203in_dols
infall939403in_fall
infalls1038943infalls
ingates82716913ingates
inhale9411513in_hale
inhales10511863in_hales
inhauls1035523inhauls
initial7311883initial_
inkstand1343803inkstand
inkstands1443193inkstands
inlays9389873in_lays
inmates92715783inmates
inositols943563inositols
inroads837043inroads
insane6314883ins_ane
inscape1138013inscape
inscapes1237813inscapes
insculp1143793insculp
insculps1243393insculps
inseam8329993insea_m
insects93710843insects
inserts74013993inserts
insets64016133ins_ets
insides8512653insides
insists739083insists
insnare748243insnare
insnares858083insnares
insole63515863ins_ole
insoles73516243insoles
insoul638463insoul_
inspan837513inspa_n
installed1045843installed
installer945003installer
installers1043623installers
instance1049873instance
instances1148743instances
instancy1346563instancy
instantly1256013instantly
instated91613343instated
instead836203instead
instep838193inst_ep
insular7138703insular
insulars8137323insulars
insult62813673ins_ult
insults7268963insults
insures73117263insures
intact8314663in_tact
intagli845023in_tagli
intake10510863in_take
intakes11310943in_takes
inters64328053in_ters
inthrals11258503inthrals
intis55121643in_t_is
intros64215773in_tros
inutile739883inutile
invars9310003in_vars
invital1046953invital_
inwall938343in_wall
inwalls1037283inwalls
inwraps12105253inwraps
iotas54821113i_ota_s
isbas71010403i_sba_s
istle52214713i_st_le
istles62814983i_stles
jingals1588073jin_gals
lanitals837723lanitals
linguals9317223linguals
lintels73311163lin_tels
lintols7339553lin_tols
listels74212433listels
mainstays1443383mainstays
mescals112911553mescals
metals84520883_metals
minerals10311373minerals
minimals12327433minimals
minsters103813923minsters
minstrels1145693minstrels
miskals13369763miskals
missals93914423missals
mistrals101212623mistrals
mortals93914003mortals
nasals63312463_nasals
natal53921493_natal_
nopals84914023_nopals
notal55221353_notal_
onstage838363onstage
pascals11610013pascals
pastas85422873pasta_s
pastels95215183pastels
pastils94416173pastils
petals84719813_petals
pinatas93711503pinata_s
pineals93212843pin_eals
pinitols1046103pinitols
pintails10310163pin_tails
pintas85021393pin_ta_s
pistils93314303pistils
pistols93213983pistols
portals94015563portals
postal84317533postal_
qintars16268573qin_tars
quintals17288003quin_tals
rascals959663rascals
ratals64219583_ratals
reinstall944553reinstall
reinstalls1044213reinstalls
rentals74017473rentals
reseals73917663reseals
ringhals1256263ringhals
ringtails1044443ringtails
ringtaws1243563ringtaws
sals46851673__s_als
seals54839693__seals
sials54227243__sials
siestas738813siesta_s
sisals63013573sis_als
spitals93011593spitals
stabs76221383__stabs
stags66226743__stags
stale55637103__stale
stales65538293__stales
stalk94518003__stalk
stalks104614553__stalks
stall54722353__stall
stalls64019933__stalls
stars55836573__stars
stats55933363__stats
stays86022023__stays
steals64020063__steals
tincals93610643tin_cals
tinsels738373tins_els
totals63115163_totals
uncials92510523uncials
uninstall953203uninstall
uninstalls1052913uninstalls
unsays9399543uns_ays
unseal63315473unseal_
unseams9338913unseams
unseats73012853unseats
unsells73210773unsells
unsnags835463unsnags
unsnaps935423unsnaps
unsnarls894883unsnarls
unstable10313763unstable
unstably1339493unstably
unstack1337373unstack
unstacks1446043unstacks
unstate71916213unstate
unstates81314993unstates
unsteels845793unsteels
unsteps936213unsteps
unstops936993unstops
unstraps1045983unstraps
usuals637783_usuals
vassals1057953vassals
vestal94615573vestal_
vestas95916683vesta_s
vinals94716483vin__als
vistas94513273vista_s
visuals1036853visuals
vitals94514303_vitals

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.453394461.4
2DLD Change Limit1340272266.81319672.2
3Display Results2262260.0762973.7
 (SQL Overall)1786912267.34224338.2
 
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.