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

You can choose a higher Change Limit to return more words, although it will take longer.
to automatically increase the Change Limit after seconds.

99 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
dryer9511146(None) 
drier64423961drier
dryers10449271dryers
dyer85522111d_yer
fryer115913431fryer
pryer104415311pryer
wryer11489301wryer
armer76924442armer
brayer115315312brayer
brier74527402brier
buyer105013092buyer
coyer105222842coyer
crier74724462crier
darer65230792darer
darker114718692darker
darner74017302darner
darter75320362darter
dater65332312dater
deer56739022d_eer
defer94619752defer
deter65028042deter
dicer85426422dicer
diker105524552diker
dimer85625602dimer
diner65632902diner
direr64927072direr
diver94827802diver
doer57734702d_oer
doper86128392doper
dormer94415902dormer
dorper94314572dorper
dorser74819182dorser
doser66228562doser
doter65428622doter
dower95027702dower
doyen95014412doyen
dozer158419272dozer
draper94315692draper
drawer104711362drawer
drayed115911392drayed
drear65016902drear
dree56638322dr_ee
dreed75222842dreed
drees65628522drees
dreg66821652dr_eg
drek96321092dr_ek
drew86221672dr_ew
dried75321382dried
driers74516732driers
dries64733672dries
driver104714492driver
droner74717672droner
drover104614592drover
dry76526032dry__
dryad10477582dryad
dryest104811122dryest
dryly12538452dryly
drys86314802dry_s
duper85519002duper
dye75334842d_ye_
dyed96720762d_yed
dyers96617132d_yers
dyes85331892d_yes
eyer76127282_eyer
feyer115014522feyer
flyer114916252flyer
foyer116416552foyer
freer86021242freer
frier85225842frier
fryers125710972fryers
gayer94519192gayer
grayer106014542grayer
greyer104510092greyer
hayer114620242hayer
layer84626472layer
order65019362order
ormer75218372ormer
oyer75927652_oyer
payer105125722payer
plyer106214332plyer
prayer114815292prayer
preyer114413732preyer
prier75027762prier
pryers115012242pryers
ruer46127562_ruer
rye66032542_rye_
ryes75529352_ryes
sayer84926552sayer
shyer114714782shyer
slyer85515122slyer
spryer11418532spryer
toyer84521552toyer
trier54328532trier
truer54916642truer
tuyer85414292tuyer
twyer11558522twyer
tyer75323392_tyer
urger64116472urger
wrier84521752wrier

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 Filter178691538000.296603685.8
2DLD Change Limit53800991.36039558.8
3Display Results99990.0303300.0
 (SQL Overall)178691991.686105985.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.