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

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

88 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
afflux1942791afflux
affray1534972affray
efflux1942002efflux
waffly18305432waffl_y
ably99725133a_bl_y
aff95537613aff___
affably1855183affably
affair1234353affair
affect1448903affect
affine12310503affine
affirm1435523affirm
affix1836003aff_ix
afflatus1442683afflatus
afflict1547043afflict
affluency20102673affluency
affluent1494553affluent
affluxes2142533affluxes
afford1346493afford
affrays1644063affrays
afoul8510193a_foul
agley96917333a_gley
agly86821803a_gl_y
alky115920343a__lky
allay85620393a_llay
alley85721673a_lley
alloy85519973a_lloy
ally76935643a__lly
alum65227613a__lum
amply125012913ampl_y
amylum1344693amylum
anally9513503anally
apply125111393appl_y
aptly105111813aptl_y
asylum1144893asylum
awful1178143awf_ul
awfully1644003awfully
baffle14399873baffl_e
baffled16418063baffled
baffler15418113baffler
baffles153710683baffles
baffy165511923baff__y
barfly14339653barfl_y
daffily1735133daffily
daffy155510283daff__y
daftly1335443daftl_y
dayfly1633813dayfl_y
effigy1642213effigy
fatly115716803fatl_y
faulty12429363faulty
felly114922803_felly
filly114424903_filly
filmy136114043_filmy
filum105015433_filum
flay106332803__flay
fley106626853__fley
flu66530213__flu_
flub95721883__flub
flue75329853__flue
fluky154512293__fluky
flus75626543__flus
fluty114415643__fluty
flux145617743__flux
fluyt114614203__fluyt
fly97124953__fl_y
foley115222303_foley
folky159214713_folky
folly115022603_folly
fully114820863_fully
gadfly1434663gadfl_y
iffy135312283iff__y
influx1643723influx
mayfly1734403mayfl_y
offcut1444703offcut
offkey1932343offkey
raffle123910703raffl_e
raffled14429083raffled
raffler13339223raffler
raffles133611843raffles
reflux16315413reflux
refly113914563refl_y
ruffly15336673ruffl_y
safely12249393safel_y
sawfly1535133sawfl_y
taffy145110823taff__y
waffle15369183waffl_e
waffled17357523waffled
waffler16377783waffler
waffles16329983waffles

Search took 6 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 Limit112716884.69024033.3
3Display Results88880.0302933.3
 (SQL Overall)178691885.09335085.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.