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 “snipe” with Change Limit: [1] [2]

(Found more than 100 similar words, so Change Limit cannot be increased.)
to automatically search another random word after seconds.

117 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
snipe7532057(None) 
sipe67341041s_ipe
slipe75626131slipe
snide64318721snide
snip66424651snip_
sniped94913481sniped
sniper84413641sniper
snipes83917391snipes
snips75818011snips
stipe76523371stipe
swipe105217081swipe
anile54634462anile
anime75423202anime
anise55129702anise
cripe95521142cripe
gripe84622962gripe
knife1210010132knife
lipe66839732_lipe
nape65230802_nape
nice65534712_nice
nide55535792_nide
nine45842172_nine
nip56945982_nip_
nipa69421632_nipa
nips65830922_nips
nite45943582_nite
nixe115722022_nixe
nope65934192_nope
pipe86434432_pipe
ripe66038922_ripe
saice75424052saice
scape96921842scape
scope94821482scope
seine55732872seine
seise54727852seise
seize143819502seize
senile63420212senile
shape105125112shape
shine85533092shine
ship95228242ship_
ships105123772ships
shire84727132shire
shive114423422shive
sice65545592s_ice
side55444492s_ide
sike87138782s_ike
since75024172since
sine46560622s_ine
singe65731132singe
sip57656012s_ip_
siped84927682s_iped
sipes76036952s_ipes
sips65740102s_ips
sire46150412s_ire
site47052412s_ite
size135630962s_ize
skip105421752skip_
skips115616602skips
skite95120052skite
skive124614112skive
slice74925822slice
slide64725412slide
slime74925752slime
slip67031732slip_
sliped95417062sliped
slipes84921412slipes
slips76023722slips
slipt76627482slipt
slope75823562slope
slype105112362slype
smile74823922smile
smite75224872smite
snake94821112snake
snap65727032snap_
snaps74719562snaps
snare54429982snare
snib66522982sni_b
snibs75613762snibs
snick114416012snick
snider74413912snider
sniff113915862sniff
snipers93311772snipers
snipped123510042snipped
snipper113911332snipper
snippet113310432snippet
snippy1374842snippy
snit46342472sni_t
snits54124832snits
snivel9368852snivel
snore55424952snore
snye77115492sn_ye
spice95528812spice
spike114922842spike
spile75230082spile
spine76534422spine
spire75828692spire
spite75430662spite
stile54931572stile
stime76521802stime
stiped94517072stiped
stipel84412122stipel
stipes84524052stipes
stope74727242stope
stripe85822442stripe
stupe75217752stupe
suite54829562suite
supe65932762s_upe
swine85625302swine
swiped123811092swiped
swipes114114332swipes
swiple11379232swiple
swive115316192swive
tripe75425382tripe
unite54828382unite
unripe82012092unripe
wipe94830282_wipe
yipe96722182_yipe

Search took 3 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 Filter178691538000.313570897.8
2DLD Change Limit538001171.65632487.9
3Display Results1171170.0303900.0
 (SQL Overall)1786911171.99989390.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.