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

121 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
install77936(None) 
instal6712191insta_l
installs858921installs
instals7611711instals
instill789061instill
infall939402in_fall
instable10313202instable
installed1045852installed
installer945012installer
instant7815352instant
instar6310012insta_r
instars7411132instars
instate71616482instate
instil61111382inst_il
instills867352instills
instils7811452instils
inwall938342in_wall
reinstall944572reinstall
stall54722352__stall
uninstall953202uninstall
ainsell796393ains_ell
costal85419513costa_l
costally1339733costally
distal73615773dista_l
distally1239553distally
distill83011323distill
ensnarl784913ensnarl
entail61114343en_tail
fastball1344913fastball
festal94213563festa_l
festally1437543festally
gestalt8411173gestalt
gingall9117333gin_gall
icefall1254313icefall
indwell1143903indwell
infalls1038943in_falls
infill938413in_fill
inhale9411523in_hale
inhaul936803in_haul
initial7311883initial
initially1249063initially
initials848103initials
inkstand1343803inkstand
inkwell1442533inkwell
insane6314893ins_ane
inscape1138023inscape
inscroll10113213inscroll
insculp1143793insculp
inseam8329993insea_m
inseams9307903inseams
insnare748243insnare
insole63515863ins_ole
insoul638463ins_oul
insouls737213insouls
inspan837513inspa_n
inspans937803inspans
installers1043633installers
installing1146403installing
instance1049883instance
instancy1346573instancy
instantly1256013instantly
instants8910153instants
instated91613343instated
instates81615833instates
instead836203instead
instep838193inst_ep
insteps936573insteps
instilled1045303instilled
instiller944953instiller
insular7138713insular
insult62813673ins_ult
intact8314663in_tact
intagli845023in_tagli
intake10510863in_take
inthrall11247063inthrall
inutile739883inutile
invital1046953invita_l
inwalls1037283in_walls
istle52214713i_st_le
jingall1566173jin_gall
minstrel1046913minstrel
miscall1139653miscall
natal53921493_nata_l
notal55221353_nota_l
nutgall844443_nutgall
onstage838363onstage
pinball1137933pin_ball
pintail9311183pin_tail
postal84317533posta_l
postally13310273postally
postals93716383postals
reinstalls1044213reinstalls
ringtail944723ringtail
sall44544683__s_all
scall74420373__scall
shall85024053__shall
small74016263__small
spall74919303__spall
stale55637103__stale
stalk94518003__stalk
stalls64019933__stalls
still54922083__still
stull54916273__stull
tall47240213___tall
uninstalls1052913uninstalls
unseal63315473unsea_l
unseals73212583unseals
unsell63512543uns_ell
unshell1047113unshell
unsnarl7107153unsnarl
unstable10313763unstable
unstably1339493unstably
unstack1337373unstack
unstate71916213unstate
unsteel738793unsteel
vestal94615573vesta_l
vestally1437413vestally
vestals104612333vestals
whipstall1752553whipstall
windfall1544203windfall
windgall1343853windgall

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.423422437.4
2DLD Change Limit1340271215.93622578.7
3Display Results1211210.0462630.4
 (SQL Overall)1786911216.40527898.7
 
Comments and Suggestions welcome: FaceBook ~ UserVoice ~ SQLServerCentral  |  Developed By: Tom Keller Consulting © 2011-2026  |  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.