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

213 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
wry9652470(None) 
awry107619681awry
cry89726241cry
dry76526031dry
fry96226501fry
pry85728051pry
try66529671try
wary106740011wary
way96757661way
why126920011why
wiry106422831wiry
aby810238062aby
aery77231682aery
airy75734152airy
any68440482any
ar211379382ar_
arb510448422arb
arc510250902arc
are37874572are
arf67453372arf
ark77044962ark
arm58449622arm
army96624182army
ars37670932ars
art38679142art
arty77531312arty
aryl75922342aryl
away108024222away
awny105919302awny
ay511773892_ay
bay89661642bay
bey86645422bey
boy87753562boy
bra56339462bra
bray95232902bray
bro56236602bro
brr56921922brr
bury95633592bury
buy86436542buy
by77529232_by
cay87155982cay
cory96941512cory
cowry135512482cowry
coy810557552coy
cru57129562cru
day76254112day
dey77243372dey
dory85836232dory
dowry126312482dowry
dray85428092dray
drys86314802drys
eery76129622eery
er28345142er_
era35741502era
ere36352772ere
erg45531072erg
ern35738352ern
err35626532err
ers36046282ers
eyry106315882eyry
fay97454862fay
fey95940882fey
fly97124952fly
foy96044262foy
fray105428902fray
fro65530642fro
fury107727972fury
gay76856492gay
gey75738302gey
gory86129662gory
goy77844552goy
gray85329892gray
grey85624042grey
guy75728942guy
hay97358772hay
hey96741062hey
hoy97447912hoy
icy86322122icy
ire36943172ire
irk76426362irk
ivy96317442ivy
jay136242672jay
joy137036362joy
jury146719592jury
kay106745542kay
key105833332key
lay68865352lay
ley66246812ley
lory75931712lory
may88757622may
miry96326742miry
my78125652_my
nary76931222nary
nay66952772nay
or27354732or_
ora37250832ora
orb55736862orb
orby97519602orby
orc57034922orc
ore36661832ore
orgy85218002orgy
ors35750112ors
ort39465232ort
oryx14510212oryx
oxy136320982oxy
oy58950132_oy
pay88461182pay
ply86323552ply
pray96331532pray
prey96228482prey
pro55837262pro
ray66361992ray
re26153742_re
rya67622012_rya
rye66032542_rye
say67264762say
scry96017762scry
shy96728192shy
sky106420992sky
sly66228562sly
soy67851452soy
spry96819122spry
spy86023742spy
sri35634002sri
sty66227312sty
sway107128232sway
thy97022912thy
tory75840542tory
toy69655192toy
tray77632592tray
trey77228792trey
troy77429682troy
urb55731102urb
urd46427042urd
urn35731462urn
urp56426392urp
vary105226062vary
very108025642very
wab87051832wab
wad77053892wad
wady115324992wady
wae67556952wae
wag76451752wag
waly105830902waly
wan66761932wan
wany106432352wany
wap86553372wap
war67262422war
ward86542252ward
ware76254722ware
wark115737772wark
warm95935672warm
warn75239322warn
warp95635002warp
wars78659802wars
wart77866082wart
warty119323822warty
was68767562was
wat67378922wat
wavy136620472wavy
waw97046382waw
wax137041182wax
waxy175918202waxy
ways107737952ways
we57043452w_e
weary115620612weary
web85735562web
wed75843622wed
wee66760812wee
wen66249602wen
were76238332were
wert79749822wert
wet65966622wet
wha96422072wha
whey135018712whey
who95526772who
whys137011662whys
wig76740382wig
wily106428812wily
win66456292win
winy107034322winy
wire75839812wire
wis66552332wis
wit66563772wit
wiz156434152wiz
wo510447762w_o
woe66651242woe
wog76242732wog
wok106334172wok
won66252062won
woo66949802woo
wop87145132wop
word89832002word
wordy126916162wordy
wore77144672wore
work115528842work
worm96129482worm
wormy137514252wormy
worn75631752worn
worry116114332worry
wort76654752wort
wos66953532wos
wot610467482wot
wow96643472wow
wrap96821972wrap
wren78221682wren
writ75537912writ
wryer11489302wryer
wryly14356702wryly
wud76227152wud
wye96331972wye
wyn95921442wyn
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.0463884587.0
2DLD Change Limit140842130.37637457.4
3Display Results2132130.0307100.0
 (SQL Overall)1786912130.452395334.1
 
Comments and Suggestions welcome: FaceBook ~ UserVoice ~ SQLServerCentral  |  Developed By: Tom Keller Consulting © 2011-2024  |  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.