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

214 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
spy8602374(None) 
espy969371espy
say67264761say
shy96728191shy
sky106420991sky
sly66228561sly
soy67851451soy
spa55730811spa
spay96631661spay
spry96819121spry
sty66227311sty
aby810238062aby
any68440492any
ape57251182ape
apo511142122apo
app76827602app
apt57352542apt
ashy107717352ashy
asp57235342asp_
asps65622092asps
ay511773892_ay
bay89661642bay
bey86645422bey
boy87753562boy
buy86436542buy
by77529232_by
cay87155982cay
copy116229802copy
coy810557552coy
cry89726242cry
day76254112day
dey77243372dey
dopy106224152dopy
dry76526032dry
fay97454862fay
fey95940882fey
fly97124952fly
foy96044262foy
fry96226502fry
gapy106320912gapy
gay76856492gay
gey75738302gey
goy77844552goy
guy75728942guy
gyp98319012gyp
hay97358772hay
hey96741062hey
hoy97447912hoy
hyp117822462hyp
icy86322122icy
ivy96317442ivy
jay136242672jay
joy137036362joy
kay106745542kay
key105833332key
lay68865352lay
ley66246812ley
may88757632may
mopy115721972mopy
my78125652_my
nay66952772nay
op45850162op_
ope56845242ope
ops56641252ops
opt57545542opt
oxy136320982oxy
oy58950132_oy
pa410456482_pa
pay88461182pay
pe47649032_pe
pi48145362_pi
pipy115421512pipy
ply86323552ply
pry85728052pry
psi56621622psi
pst57932512pst
pya87023752_pya
pye86432502_pye
pyx157817012_pyx
raspy106511702raspy
ray66361992ray
ropy96323412ropy
sab56563202sab
sac57452862sac
sad47459202sad
sae38365182sae
sag46163402sag
sagy85327082sagy
sal36462882sal
sap56463232sap
sappy125413472sappy
saps65346372saps
sat36288482sat
sau36356572sau
saw68255352saw
sax107447642sax
says75942102says
scry96017762scry
sea36161292sea
sec55945322sec
see35772262see
seepy104717972seepy
seg45544882seg
sei36048932sei
sel38253322sel
sen36058522sen
sepoy10314302sepoy
sept65844362sept
ser36752402ser
set36681252set
sew66247262sew
sex107043222sex
sexy146418022sexy
sh56828522s_h
sha69837782sha
shay107133342shay
she66837692she
shh97121072shh
si29149572s_i
sib56850312sib
sic55847872sic
sim56553142sim
sin36265892sin
sip57656012sip
sipe67341042sipe
sips65740102sips
sir35746672sir
sis37360542sis
sit35877752sit
six105339742six
sizy164816392sizy
ska76925862ska
ski74925692ski
slay76436382slay
snye77115492snye
so28855442s_o
soapy106114782soapy
sob57857942sob
sod46053702sod
sol37256622sol
som59153812som
son37761952son
sop57557862sop
soph97024202soph
sophy136611762sophy
soppy125113522soppy
sops65244562sops
sos37761602sos
sot310384302sot
sou37853692sou
soupy106115402soupy
sow66554762sow
sox106444192sox
soya75724432soya
soys75233932soys
spacy125415622spacy
spae65034322spae
spam85930042spam
span65234662span
spar65433302spar
spas67036722spas
spat66548522spat
spays105520512spays
spaz155626162spaz
spec85821972spec
sped76031492sped
spew95421872spew
spic85227432spic
spicy125417712spicy
spik105419712spik
spiky146014112spiky
spin66231302spin
spiny104921302spiny
spiry105017352spiry
spit65545082spit
spiv95917792spiv
splay105816042splay
spot65540692spot
spray106720062spray
spud75818492spud
spue66025522spue
spumy124610362spumy
spun66221462spun
spur65321192spur
sri35634002sri
stay78333722stay
stey76224412stey
stye76218972stye
sub55445552sub
sue35651462sue
suk75632972suk
sum56346012sum
sun37149032sun
sup57041942sup
supe65932762supe
sups64834432sups
suq126228992suq
sway107128232sway
syn67024122syn
syph125413272syph
thy97022912thy
toy69655192toy
try66529672try
typy126013042typy
up47832822up_
upby1139062upby
upo58925862upo
ups55629052ups
waspy135410992waspy
way96757662way
why126920012why
wispy137210972wispy
wry96524702wry
yay96948712yay

Search took 1 second 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 Filter178691140840.250714764.0
2DLD Change Limit140842140.36039122.2
3Display Results2142140.0464652.2
 (SQL Overall)1786912140.656272394.8
 
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.