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

191 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
flier8602340(None) 
filer85433001filer
fleer86020771fleer
flied96519431flied
fliers94417191fliers
flies85630711flies
flir76422201fli_r
flyer114916251flyer
frier85225841frier
lier45942461_lier
plier75221281plier
slier54827241slier
alder65421912alder
alien56425582alien
aliner65621982aliner
alter54828502alter
belier84423562belier
bier65531832_bier
bluer74918492bluer
brier74527402brier
crier74724462crier
drier64423962drier
eelier64216462eelier
elder64020022elder
elmier839812elmier
elver85216242elver
facer105525052facer
fader94421512fader
fainer94717242fainer
fair76332522fai_r
fairer95212062fairer
faker124824592faker
faller94621232faller
falser93912412falser
falter94519052falter
farer86733142farer
feller94419552feller
fer66646122f__er
fever115617952fever
fewer115216122fewer
feyer115014522feyer
fiar76427332f_iar
fiber104921132fiber
fie67152442f_ie_
fief107331362f_ief
fiery114714792f_iery
fifer115519972fifer
filar84819292filar
file75446642file_
filed95331902filed
filers94623722filers
files85441272files
filet85540162filet
filler94623622filler
filmer114112402filmer
filmier1237502filmier
filter94517632filter
finer85431562finer
fir66744892f_i_r
fire76245592f_ire
firer811229252firer
fiver116024942fiver
fixer154717832fixer
flair86114122flair
flaker134916172flaker
flakier143910202flakier
flamer114919122flamer
flamier123112142flamier
flare84823632flare
flawier13378732flawier
flaxier17337982flaxier
flayer124713562flayer
flea75628492fl_ea
fled85429772fl_ed
flee76238792fl_ee
fleers96015792fleers
flees85828752flees
fleet85932332fleet
flew105824252fl_ew
flex146123472fl_ex
fley106626852fl_ey
flic96223732fli_c
flick145017212flick
flicker163610622flicker
flics105418362flics
fliest94718432fliest
flinder11319872flinder
fling97023512fling
flinger113710512flinger
flint87333502flint
flip96324262fli_p
flipper14389142flipper
flips105117742flips
flirs85518932flirs
flirt87424752flirt
flirter10318672flirter
flit76539272fli_t
flite85424962flite
flited104616582flited
flites95122442flites
flits85625222flits
flitter103413902flitter
flivver1633042flivver
floe76129772floe_
floes85528142floes
floor84215232floor
flour84916452flour
flower124815502flower
flue75329852flue_
flued95021252flued
flues84626922flues
flukier14397852flukier
fluor84512772fluor
fluter95316862fluter
flutier103011552flutier
flyers125712802flyers
flytier13356502flytier
folder104317542folder
foliar93210972foliar
folkier14359042folkier
foxier163910032foxier
foyer116416552foyer
fozier183710662fozier
freer86021242freer
friar85414272friar
fried95322912fried
friers94718932friers
fries85535602fries
frizer184011282frizer
fryer115913432fryer
fuller94220382fuller
fumer105918232fumer
fumier11310902fumier
glider84614262glider
gluer65116772gluer
gluier7310262gluier
holier94921622holier
icier74313752icier
iffier1236762iffier
iller54821292iller
inlier63615362inlier
kier86526812_kier
leer46239352_leer
liar47229682_liar
liber74723622_liber
lie38264522_lie_
lied55838092_lied
lief76036992_lief
lien45339802_lien
liers55130402_liers
lies46454192_lies
lieu46534362_lieu
lifer85822152_lifer
liger65024472_liger
liker95627062_liker
liner55938922_liner
lire47845292_lire
liter54736342_liter
liver85132962_liver
miler75733062miler
oiler54628282oiler
oilier64417232oilier
older65121172older
osier53518012osier
palier85023562palier
pier66035292_pier
plie65127392plie_
plied85118592plied
pliers84715152pliers
plies74526512plies
plyer106214332plyer
prier75027762prier
relier65826182relier
rulier65016352rulier
shier85428942shier
skier95119592skier
slicer84117602slicer
slider73918362slider
sliver94116592sliver
slyer85515122slyer
spier75728032spier
tier44936142_tier
tiler56131022tiler
trier54328532trier
twier84713292twier
uglier748952uglier
ulcer7310752ulcer
vier75428152_vier
viler86324162viler
wilier93217072wilier
wrier84521752wrier

Search took 3 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 Limit538001911.95327547.4
3Display Results1911910.1101736.4
 (SQL Overall)1786911912.35975748.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.