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

(Found more than 100 similar words, so Change Limit cannot be increased.)
to automatically search another random word after seconds.

172 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
reflux1631541(None) 
reflex16359511reflex
afflux1942792afflux
efflux1942002efflux
flux145617742__flux
influx1643722influx
redux133811102re_dux
refix155212482ref_ix
reflag1098082reflag
reflet94024232reflet
reflew12389452reflew
reflow12379652reflow
refluxed1954352refluxed
refluxes1855182refluxes
refly113914562refl_y
reglue739702reglue
relax124817802re_lax
beaux146513213be_aux
beflag1265883beflag
beflea1147123beflea
befoul1137253befoul
biflex1834953biflex
conflux1943003conflux
deflea1037443deflea
deluxe14197303de_luxe
eaux116618423_e_aux
faux146519073__faux
flax147325633__flax
flex146123473__flex
flu66530213__flu_
flub95721883__flub
flue75329853__flue
flus75626543__flus
hallux1637363hallux
helix154413013he_lix
ireful948713iref_ul
jeux184311273je__ux
lux106528773___lux
peplum12156823peplum
peplus10138343peplus
prefix18356853pref_ix
reaffix2042323reaffix
real45750293real__
realer63528593realer
reales64934123reales
realia6314593realia
really93315613really
realm75621623real_m
realms84913493realms
reals55038653real_s
realty92713693realty
rebus75721113re_bus
rebut75927383re_but
rebuy104714683re_buy
reclad9311873reclad
recluse95210773recluse
recoup10810373recoup
rectum103411283rectum
rectus83314633rectus
recur74116843re_cur
recut74729243re_cut
redbud10135803redbud
redbug10165473redbug
redleg839273redleg
redly94217203redl_y
redout71820253redout
redox134714233re_dox
redub84212413re_dub
reel45240533reel__
reeled74725533reeled
reeler63822573reeler
reels55333263reel_s
ref66053293ref___
reface113616353reface
refall94314393refall
refalls103312243refalls
refect114319333refect
refed93921923ref_ed
refeed104717623refeed
refeel93913243refeel
refel84920813ref_el
refell94214443refell
refels94618053refels
refelt94521423refelt
refer84822143ref_er
refers93921083refers
reffed134712513reffed
refile95122373refile
refiled114318653refiled
refiles104122423refiles
refill94514053refill
refills103711423refills
refilm114311403refilm
refilms12347503refilms
refind104717073refind
refine95225693refine
refire95419473refire
refit84230063ref_it
refits94017653refits
reflags1156953reflags
reflate103516263reflate
reflect123913713reflect
reflets103513153reflets
reflexed1975253reflexed
reflexes1865933reflexes
reflexly2142463reflexly
reflies104418533reflies
refloat10310833refloat
reflood1136363reflood
reflown13316213reflown
reflows13258983reflows
refluent1147443refluent
refluxing2034583refluxing
refocus1236973refocus
refold103812113refold
refolds11298953refolds
reform11312723reform
refound1157413refound
refry114412463ref_ry
refs75732243ref__s
reft75141273ref__t
refuel93912623refuel
refuge105312613refuge
refund104810303refund
refuse94817513refuse
refute95515703refute
regius7311923regius
reglet73724233reglet
reglow10339403reglow
reglued936333reglued
reglues838713reglues
regnum957163regnum
reguli738143reguli
regulus836523regulus
relay84424673re_lay
relet54749823re_let
relic74623363re_lic
relit55340683re_lit
reluct83916113re_luct
relume8313273re_lume
rely75428953re_l_y
remex146315793re_mex
remix145916553re_mix
replan83215823replan
replay113412923replay
repled93319783repled
replot83818593replot
replow114210343replow
replumb1343393replumb
reply104015853repl_y
repour8310993repour
rerun58722153re_run
rescue8313003rescue
reseaux14326233reseaux
result6318223result
retax124517973re_tax
revalue1038153revalue
revue81114453re_vue
rewax155713923re_wax
rex105740993re___x
rifle85518333rifl_e
rifled104115003rifled
rifler94014263rifler
rifles94217713rifles
riflip1134723riflip
roux117419363r__oux
rueful948203ruef_ul
rufous948273rufous
teflon937453teflon
telex125214823te_lex
vellum1136773vellum
velum10713383ve_lum

Search took 7 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 Filter1786911127160.373479064.3
2DLD Change Limit1127161725.75019602.8
3Display Results1721720.0632730.2
 (SQL Overall)1786911726.18628886.4
 
Comments and Suggestions welcome: FaceBook ~ UserVoice ~ SQLServerCentral  |  Developed By: Tom Keller Consulting © 2011-2026  |  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.