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

200 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
troy7742968(None) 
stroy87720391stroy
tory75840541tory
toy69655191t_oy
tray77632591tray
trey77228791trey
trod57627951trod
trog57628211trog
trop66833301trop
trot46351311trot
trow78031421trow
troys86418611troys
try66529671tr_y
ahoy101919182ahoy
army96624182army
arty77531312arty
boy87753562_boy
bray95232902bray
bro56236602bro_
broo65129822broo
bros65635662bros
brosy106115382brosy
brow97228442brow
buoy95921782buoy
cloy96623832cloy
cory96941512cory
coy810557552_coy
croc85723732croc
crony105918672crony
crop87628632crop
crow96428132crow
cry89726242cr_y
dory85836232dory
dray85428092dray
drop75324402drop
dry76526032dr_y
eros45238452eros
foy96044262_foy
fray105428902fray
fro65530642fro_
froe75329992froe
frog85624362frog
from96923922from
frow106425052frow
fry96226502fr_y
gory86129662gory
goy77844552_goy
gray85329892gray
grey85624042grey
grody103412062grody
grog65923342grog
grok95819682grok
grot55942052grot
grow86127302grow
hoy97447912_hoy
iron46728462iron
irony85015902irony
joy137036362_joy
lory75931712lory
orby97519602orby
orgy85218002orgy
oy58950132__oy
ploy96123602ploy
pray96331532pray
prey96228482prey
pro55837262pro_
proa66229962proa
prod76129502prod
prof96134662prof
prog75729002prog
prom87631702prom
prop85932812prop
pros65742782pros
prosy106319252prosy
prow97030382prow
proxy175011012proxy
pry85728052pr_y
ray66361992_ray
rob56754302_rob
roc520243252_roc
rod47953892_rod
roe36861082_roe
rom59855632_rom
ropy96323412_ropy
rosy76024872_rosy
rot37282952_rot
row67453672_row
soy67851452_soy
story86723032story
stray88525572stray
strop77422242strop
strow88920572strow
stroys95914602stroys
tao38358952tao_
taos45541002taos
tardy94720462tardy
taro46846912taro_
taroc75721642taroc
tarok97921072tarok
taros55640822taros
tarot55943932tarot
tarry85422512tarry
tarty86328182tarty
tepoy10312162tepoy
terry84721872terry
they107223752they
tho67433962tho_
thou76722212thou
thro77726422thro_
throb109816852throb
throe89321422throe
throw118719732throw
thy97022912t_hy
tidy86822412tidy
tiny76134632tiny
tiro46832362tiro_
tiros54524892tiros
tivy1014516862tivy
to218858982t_o_
toby96322292toby
tod49457072t_od
tody86327212tody
toe310166852t_oe
tog410255042t_og
tom514358052t_om
ton310265102t_on
tony75635152tony
too38965422t_oo
took86531072took
tool46735682tool
toom66532932toom
toon47740632toon
toot45958882toot
top510560682t_op
tor39261682t_or
tora47545992tora
torc66333352torc
tore47359322tore
tori47542152tori
torn46044252torn
toro48045682toro
toros54336192toros
torot56139942torot
torr45630902torr
tors46157382tors
tort46967462tort
tot38884772t_ot
tow610557362t_ow
towy105325472towy
toyo76925452t_oyo
toys78036342t_oys
trad55630912trad
tram67034552tram
trap67532802trap
trays85623432trays
tree47745812tree
tref77030992tref
trek86222312trek
tres46542902tres
tret46653532tret
treys85018212treys
trig55528162trig
trim65329522trim
trio45233342trio
triol55521362triol
trios55528092trios
trip66830392trip
troak95213572troak
trock114817602trock
trode65322852trode
trogs67022602trogs
trois57226092trois
troke94821052troke
troll54416532troll
trolly94012362trolly
tromp95815802tromp
trona54118952trona
trone55131862trone
troop76417532troop
trooz145016152trooz
trope75725802trope
trophy1438282trophy
troth85622202troth
trots56629942trots
trotyl9236672trotyl
trout57332572trout
trouty95211792trouty
trove85221922trove
trows88826182trows
true46725852true
trug55720042trug
truly84111552truly
turfy114315402turfy
two67925832two_
twos76718022twos
typy126013042typy
tyro76622362tyro_
tyros85118592tyros
vrow105817472vrow
wry96524702wr_y

Search took 2 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 Filter178691298720.1401276364.3
2DLD Change Limit298722001.54619322.1
3Display Results2002000.0464347.8
 (SQL Overall)1786912001.732103170.3
 
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.