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

184 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
fizzling2026499(None) 
fizzing19276401fizz_ing
frizzling2153111frizzling
mizzling19255441mizzling
sizzling17225781sizzling
zizzling16233921zizzling
dazzling1834362dazzling
dizzying2133022dizzying
drizzling1943022drizzling
fiddling14217872fiddling
filing103823762fi__ling
filling113520802fi_lling
foozling21275722foozling
frazzling2143152frazzling
frizzing2064802frizz_ing
fuzzing19336182fuzz_ing
grizzling1942842grizzling
guzzling18225062guzzling
muzzling19245732muzzling
nuzzling17224772nuzzling
puzzling19225392puzzling
swizzling2142492swizzling
ailing74331013ai__ling
billing103823853bi_lling
birling104317053bi_rling
buzzing18186543buzz_ing
circling1338423circling
dialing94318173di_aling
dialling10310783dialling
dibbling14247333dibbling
diddling12228743diddling
dimpling14199023dimpling
dindling112411163dindling
dirling93316073di_rling
dizening19177143dizening
fabling133413623f_abling
failing113521333f_ailing
falling113621583f_alling
fatling113815683f_atling
fazing194418643f_az_ing
feazing205411443feaz_ing
feeling113617073f_eeling
feezing204610163feez_ing
felling113321133f_elling
feruling1258873feruling
fettling1266773fettling
fibbing15339463fi_bbing
fidging133910503fi_dging
fielding13206863fielding
fifing134212343fi__fing
figging133313563fi_gging
fighting162710083fighting
figuline1256033figuline
figuring1336283figuring
filching1736113filching
fileting1239303fileting
filings115213073fi__lings
fillings122910503fi_llings
filming133210353fi_lming
finagling1434703finagling
finding124116543fi_nding
finiking16277073finiking
fining104223213fi__ning
finking154016603fi_nking
finning113615113fi_nning
firing104021723fi__ring
firming132811223fi_rming
firstling1334423firstling
fishing143913863fi_shing
fishline14237583fishline
fisting113818123fi_sting
fitting113516563fi_tting
fixating1936183fixating
fixing174813783fi__xing
fizgig2032973fi_zgi_g
fizzier18326713fizz_ier
fizzle17369713fizzl__e
fizzled19357273fizzl_ed
fizzles18339063fizzl_es
flailing12298923flailing
flatling123410013flatling
fling97023513f___ling
foaling113515843f_oaling
foiling113317653f_oiling
fondling13189353fondling
fooling113117373f_ooling
footling12239923footling
fouling113315373f_ouling
fowling143713113f_owling
fribbling1733673fribbling
frilling123011493frilling
frivoling1644493frivoling
frizing203310873friz_ing
frizzlier20122883frizzlier
fuddling14247153fuddling
fueling113615133f_ueling
fuelling123410153fuelling
fugling124212513f_ugling
fulling114019703f_ulling
fumbling16208163fumbling
furling114016563f_urling
futzing20307903futz_ing
fuzing194110643f_uz_ing
giggling10227043giggling
gilling93520383gi_lling
girdling1146823girdling
higgling14217163higgling
hilling113821773hi_lling
hireling121210993hireling
hirpling1467223hirpling
hirsling1277543hirsling
huzzaing2042433huzzaing
idling8912883_i_dling
inkling122911303_inkling
isling71213883_i_sling
jazzing2333883jazz_ing
jiggling18226363jiggling
jingling17188573jingling
kibbling17225703kibbling
killing123118723ki_lling
kindling14229623kindling
kitling123313573ki_tling
kittling1336063kittling
libeling1139873libeling
miauling1137343miauling
middling13249343middling
milling103223683mi_lling
mingling122010933mingling
nibbling13256503nibbling
nickling15278703nickling
niggling11227443niggling
nilling83619563ni_lling
oiling74925313oi__ling
pickling17239203pickling
piddling13208953piddling
piffling1745133piffling
piling95025593pi__ling
pilling103722563pi_lling
pindling122110983pindling
quizzing2643403quizz_ing
razzing1636323razz_ing
riddling11249443riddling
ridgling11258203ridgling
riesling939013riesling
riffling1556113riffling
rifling112815013ri_fling
riling74227973ri__ling
rilling84023623ri_lling
rimpling13219663rimpling
rippling13197573rippling
rivaling1239913rivaling
sibling10814423si_bling
sickling152910333sickling
sideling101012183sideling
sidling9915423si_dling
singling101913003singling
sizing163616443si_z_ing
teazling1856573teazling
tickling15309433tickling
tiling73426553ti__ling
tilling83522783ti_lling
tingling102210823tingling
tinkling13239233tinkling
tippling13196703tippling
tirling83315733ti_rling
titling83715793ti_tling
touzling1835503touzling
vialing113614163vi_aling
vialling1237223vialling
vittling1236143vittling
vizoring2134573vizoring
whizzing2333383whizz_ing
widdling14228743widdling
wiggling14217293wiggling
wildling13248083wildling
wiling103024293wi__ling
willing113821613wi_lling
wimbling16186543wimbling
wimpling16207483wimpling
windling132212263windling
winkling16298293winkling
wintling12249923wintling
witling113215813wi_tling
wizening21255463wizening

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 Filter1786911461620.406440125.6
2DLD Change Limit1461621846.18623627.9
3Display Results1841840.0802300.0
 (SQL Overall)1786911846.67226782.2
 
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.