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

215 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
flue7532985(None) 
blue65328461blue
clue65324531clue
flee76238791flee
floe76129771floe
flu66530211flu_
flub95721881flub
flued95021251flued
flues84626921flues
fluke125016891fluke
flume106021171flume
flus75626541flus
flute86823751flute
flux145617741flux
glue55628491glue
slue45332191slue
ague55725922ague
alae45643752alae
ale36572342al_e
alee46652322alee
alme65832162alme
aloe45540192aloe
alum65227612alum
blae66134642blae
blub85324872blub
blued84520322blued
bluer74918492bluer
blues75127042blues
bluet75631192bluet
bluey104817052bluey
blume95619892blume
blur66020532blur
club85819472club
clued84917682clued
clues74623032clues
cue57544182_cue
due45249862_due
else45923082else
elude64517622elude
elute54822572elute
face96140122face
fade85736342fade
fake115534942fake
false84818122false
fame95639392fame
fane75343572fane
fare76354462fare
fate75444282fate
faun76226622faun
fauve114712072fauve
faux146519072faux
fave105532962fave
faze165630042faze
fe57944742f__e
fee66862012f_ee
feme96130542feme
fere76342232fere
fete75734922fete
feu67843662feu_
feud86523022feud
feued94715662feued
feus75830752feus
fice95737112fice
fie67152442f_ie
fife106027702fife
file75446642file
fille84327402fille
filum105015432filum
fine75147952fine
fique1739142fique
fire76245592fire
five107629742five
flab96628352flab
flag87427082flag
flak116026172flak
flake125119972flake
flam96333292flam
flame105124442flame
flan76134182flan
flap96128702flap
flare84823632flare
flat77147822flat
flaw106326642flaw
flax147325632flax
flay106332802flay
flea75628492flea
fled85429772fled
fleer86020772fleer
flees85828752flees
fleet85932332fleet
flew105824252flew
flex146123472flex
fley106626852fley
flic96223732flic
flied96519432flied
flier86023402flier
flies85630712flies
flip96324262flip
flir76422202flir
flit76539272flit
flite85424962flite
floc95922122floc
floes85528142floes
flog85523892flog
flop96925452flop
flour84916452flour
flout86226202flout
flow105924922flow
flubs105515442flubs
fluent9313932fluent
fluff103913612fluff
fluid94013962fluid
fluked145112092fluked
flukes135114192flukes
flukey16459812flukey
fluky154512292fluky
flumed124915262flumed
flumes115119732flumes
flump124614722flump
flung95114582flung
flunk125014382flunk
fluor84512772fluor
flush115116072flush
fluted104917162fluted
fluter95316862fluter
flutes95421782flutes
flutey125212522flutey
fluty114415642fluty
fluxed17509672fluxed
fluxes165212932fluxes
fluyt114614202fluyt
fly97124952fl_y
flyer114916252flyer
flyte115713942flyte
foe66350812f_oe
fore78351472fore
fou66743782fou_
foul77027582foul
four76226862four
frae75330472frae
free75940182free
froe75329992froe
frug86517102frug
fub86337392f_ub
fud76335152f_ud
fuel76824732f_uel
fug76234512f_ug
fugue94313372fugue
full75229152full
fume96727632fume
fun66841142f_un
fur66637322f_ur
fuse76429992fuse
fuze166422372fuze
fyce126316832fyce
fyke145915292fyke
glee55239062glee
glued75118362glued
gluer65116772gluer
glues65125682glues
gluey95715262gluey
glug66118012glug
glum75825102glum
glume85120462glume
glut56331292glut
glute66020902glute
grue55825712grue
hue66642302_hue
kluge104910452kluge
kue76631862_kue
lee36068142_lee
leu36047402_leu
lie38264522_lie
lube64731562_lube
luce65132572_luce
lude55331642_lude
lues45943552_lues
lug46138062_lug
luge55531642_luge
lum55542932_lum
lune47140492_lune
lure45142462_lure
lute46341012_lute
luv67125772_luv
lux106528772_lux
luxe115222692_luxe
lye66533412_lye
moue65835572moue
mule65236972mule
ole37155212ol_e
plie65127392plie
plug74915992plug
plum85122102plum
plume94819462plume
plus66324832plus
pule65040952pule
roue45941742roue
rue35549262_rue
rule49938422rule
sloe45534952sloe
slub65428032slub
slued64220512slued
slues54527172slues
slug55124642slug
slum65430512slum
slur45525152slur
slut45040592slut
spue66025522spue
sue35651462_sue
true46725852true
tule45735872tule
ulu36028702ulu_
ulus45622562ulus
value85719092value
yule75725142yule

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 Limit298722151.67317855.3
3Display Results2152150.0464673.9
 (SQL Overall)1786912151.85996122.1
 
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.