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

143 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
fullering133665(None) 
bulleting1236642bulleting
bullring11388422bull_ring
faltering132211112faltering
filleting1335842filleting
filtering13199722filtering
fleering123811282f_leering
fullerene1243202fullerene
fulleries1248722fulleries
fulling114019702full__ing
hollering1337742hollering
tillering1037882tillering
ulcering1139332_ulcering
alleging1038473_alleging
alluring939073_alluring
altering91917113_altering
ashlering1344153ashlering
ballerina1146483ballerina
billeting1236633billeting
bouldering1464763bouldering
bucklering1944043bucklering
buffering1835223buffering
buggering1435193buggering
bulletin1046773bulletin_
bulletins1146333bulletins
bulling104324793bull__ing
bullrings12314623bull_rings
bullying14329293bull_ying
bumpering1636593bumpering
bunkering16207103bunkering
buttering122312523buttering
cellaring1238523cellaring
collaring12310543collaring
colleting12311053colleting
culling103921303cull__ing
cullying14297503cull_ying
culturing1236553culturing
culverin1345173culverin_
culverins1445373culverins
cumbering16108203cumbering
dulling93418273dull__ing
duplexing2042793duplexing
falling113621583fall__ing
fallowing1666433fallowing
fathering161010093fathering
fellating1339243fellating
felling113321133fell__ing
fellowing1655923fellowing
festering132413173festering
fettering132310513fettering
fevering152510083f_evering
fileting1239303f_ileting
filling113520803fill__ing
filliping1544233filliping
fingering1439193fingering
flaring114116803f__laring
fleecing14347573f_leecing
fleeing113511293f__leeing
fleeting122910323f_leeting
flexing18358993f__lexing
fleying14329873f__leying
flooring12259883f_looring
flouring123010143f_louring
flowering1636053flowering
flustering14105933flustering
fluttering14106293fluttering
foddering1535163foddering
following1665753following
fostering132411263fostering
foundering1545353foundering
fueling113615133fu__eling
fuelling123410153fuel_ling
fugling124212513fugl__ing
fuller94220383fuller___
fullered1236383fuller_ed
fullerenes1353153fullerenes
fullers103817373fuller__s
fullery13337973fuller__y
fulmining1554403fulmining
funneling1344513funneling
furling114016563furl__ing
furring114013143fu__rring
furthering1744353furthering
gallerying1543033gallerying
galleting1137623galleting
gulling94019563gull__ing
gullwing13304923gull_wing
gullying13367243gull_ying
guttering112410443guttering
haltering132212003haltering
hulling113619013hull__ing
hulloaing1384523hulloaing
hulloing12146703hull_oing
hullooing1383993hullooing
hungering14187683hungering
hunkering17227123hunkering
juddering1933763juddering
leering83417643__leering
lulling83616803lull__ing
lumbering14117933lumbering
lustering102711203lustering
moldering1367863moldering
mouldering1474283mouldering
mullein9278563mulle_in_
mulleins10277053mulle_ins
mulling103819993mull__ing
murdering1357133murdering
mustering122212333mustering
muttering122611323muttering
nulling83818063null__ing
numbering14107003numbering
palleting1238733palleting
paltering122612893paltering
pelleting1237953pelleting
peltering122011673peltering
pilfering1536393pilfering
pillaring1237643pillaring
pollening1236923pollening
puckering1835883puckering
pulling103821073pull__ing
puttering122611643puttering
quavering2235953quavering
queering1838203qu_eering
quivering2235873quivering
rubbering1435703rubbering
silvering1337923silvering
soldering1169033soldering
suckering1638103suckering
suffering1637293suffering
sulfuring1345783sulfuring
sullying12328513sull_ying
summering1458753summering
sundering11312323sundering
supering11317683su_pering
telfering1336253telfering
tuckering1635693tuckering
umbering1399433_umbering
ushering1258923_ushering
uttering91613083_uttering
volleying1643763volleying
weltering13219493weltering
wildering1456743wildering
wuthering1697803wuthering

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 Filter1786911486410.420425454.8
2DLD Change Limit1486411436.33023482.0
3Display Results1431430.0632269.8
 (SQL Overall)1786911436.81326227.9
 
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.