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

127 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
feyer11501452(None) 
eyer76127281_eyer
fever115617951fever
fewer115216121fewer
flyer114916251flyer
foyer116416551foyer
fryer115913431fryer
beer65635992be_er
buyer105013092buyer
ceder85322242ceder
coyer105222842coyer
deer56739022de_er
defer94619752defer
deter65028042deter
dryer95111462dryer
dyer85522112_dyer
eger55923572_eger
ever77027692_ever
ewer77523982_ewer
eye65539772_eye_
eyed86623232_eyed
eyen76223662_eyen
eyers86521332_eyers
eyes75837882_eyes
eyre75525252_eyre
facer105525052facer
fader94421512fader
faker124824592faker
farer86733142farer
fayed126422152fayed
fear75337792fe_ar
fearer94820182fearer
feater95224052feater
feces105625362feces
fedex1699602fedex
fee66862012fe_e_
feeb96924542fe_eb
feed84538902fe_ed
feeder103513842feeder
feel75233842fe_el
feeler93215172feeler
fees76450602fe_es
feet75352212fe_et
feller94419552feller
feme96130542feme_
femes105626222femes
femur1038682femur
fencer114613532fencer
fender103718722fender
fer66646122f__er
fere76342232fere_
feres86038182feres
fester94723512fester
fete75734922fete_
feted94420932feted
fetes85630142fetes
fetor81214532fetor
fetter94120382fetter
feuar8310242feuar
feued94715662feued
fevers125414892fevers
fey95940882fey__
feyest12311402feyest
feyly14429512feyly
fezes175220022fezes
fiber104921132fiber
fifer115519972fifer
filer85433002filer
finer85431562finer
firer811229252firer
fiver116024942fiver
fixer154717832fixer
flayer124713562flayer
fleer86020772fleer
fleyed13408812fleyed
flier86023402flier
flyers125712802flyers
foyers125413132foyers
freer86021242freer
frier85225842frier
fryers125710972fryers
fueler94313932fueler
fumer105918232fumer
gayer94519192gayer
geyser1036512geyser
greyer104510092greyer
hayer114620242hayer
heder95623642heder
hewer115719932hewer
hexer155116682hexer
jeer115426462je_er
keyed1369392keyed
layer84626472layer
leer46239352le_er
leger65721512leger
leper74820742leper
lever85125162lever
merer75126232merer
meter75130322meter
never86218642never
newer85717462newer
obeyer1135892obeyer
oyer75927652_oyer
payer105125722payer
peer66238352pe_er
peter74427592peter
plyer106214332plyer
preyer114413732preyer
pryer104415312pryer
refer84822142refer
sayer84926552sayer
seder64826762seder
seer45547042se_er
serer55935512serer
sever85426052sever
sewer84426222sewer
shyer114714782shyer
slyer85515122slyer
toyer84521552toyer
tuyer85414292tuyer
twyer11558522twyer
tyer75323392_tyer
veer76229572ve_er
vexer155513522vexer
weber10313522weber
weer75535092we_er
wryer11489302wryer

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.326548131.9
2DLD Change Limit538001271.53335094.6
3Display Results1271270.0304233.3
 (SQL Overall)1786911271.88994595.6
 
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.