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

123 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
fribbling173367(None) 
dribbling1533711dribbling
brabbling1334962brabbling
cribbing15276842cribb_ing
dibbling14247332_dibbling
drabbling1544552drabbling
dribbing14325882dribb_ing
fibbing15339462f_ibb_ing
frilling123011492fri_lling
frivoling1644492frivoling
frizzling2153112frizzling
grabbling1564582grabbling
kibbling17225702_kibbling
nibbling13256502_nibbling
quibbling2342822quibbling
rabbling13239332_rabbling
ribbing123111952_ribb_ing
rubbling13238072_rubbling
scribbling1742552scribbling
babbling12228693_babbling
bibbing11299613_bibb_ing
bobbling12238643_bobbling
brambling1635543brambling
bribing123111043bri_b_ing
bridling122610583bri_dling
brisling112410843bri_sling
bristling1246663bristling
brittling1235543brittling
bubbling12248223_bubbling
cobbling15248803_cobbling
crabbing15287933crabb_ing
cribbings16273173cribb_ings
crimpling1645343crimpling
crinkling16145863crinkling
crippling1644093crippling
crumbling1655083crumbling
dabbling14227973_dabbling
dibbing133110893_dibb_ing
drabbing14286803drabb_ing
drilling103311983dri_lling
driveling1445763driveling
drizzling1943023drizzling
drubbing14286053drubb_ing
drumbling1544033drumbling
fabling133413623f__abling
failing113521333fai__ling
fiddling14217873f_iddling
filing103823763f_i__ling
filling113520803f_i_lling
firstling1334423firstling
fizzling20264993f_izzling
flubbing16275883flubb_ing
fobbing153410273f_obb_ing
foiling113317653foi__ling
frazzling2143153frazzling
freckling1934703freckling
fribble14287783fribbl__e
fribbled16305743fribbl_ed
fribbler15265953fribbl_er
fribblers16314193fribblers
fribbles15287713fribbl_es
friending1495553friending
frigging14268953fri_gging
frighting1736023frighting
frillings13265803fri_llings
fringing133010903fri_nging
frisking16268363fri_sking
fritting123510703fri_tting
frivolling1742763frivolling
frizing203310873fri__zing
frizzing2064803fri_zzing
fubbing15409573f_ubb_ing
fumbling16208163f_umbling
gabbling14238073_gabbling
gibbing13339373_gibb_ing
gobbling14257533_gobbling
grabbing14267313grabb_ing
griddling1333933griddling
grilling103811533gri_lling
grizzling1942843grizzling
grubbing14295403grubb_ing
grumbling1544083grumbling
hobbling16227583_hobbling
jibbing19338063_jibb_ing
libeling1139873_libeling
nibbing12339553_nibb_ing
nobbling13228273_nobbling
pebbling1535073_pebbling
prickling1836533prickling
prilling113413413pri_lling
rambling131810773_rambling
ribbings13275923_ribb_ings
ribboning1443513_ribboning
riddling11249443_riddling
ridgling11258203_ridgling
riesling939013_riesling
riffling1556113_riffling
rifling112815013_ri_fling
riling74227973_ri__ling
rilling84023623_ri_lling
rimpling13219663_rimpling
rippling13197573_rippling
rivaling1239913_rivaling
robbing123313213_robb_ing
rubbing123412273_rubb_ing
rumbling131910103_rumbling
scabbling1634863scabbling
scrabbling1742853scrabbling
sibling10814423_si_bling
snibbing13295893snibb_ing
trebling1139873tr_ebling
trembling1435193trembling
trickling1647723trickling
trifling122411503tri_fling
trilling92815963tri_lling
trindling1137133trindling
tripling112712553tri_pling
troubling1234943troubling
wabbling16207743_wabbling
wimbling16186543_wimbling
wobbling16246923_wobbling
wriggling1533813wriggling
wrinkling17144953wrinkling

Search took 8 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.423422437.4
2DLD Change Limit1486411237.22020587.4
3Display Results1231230.0462673.9
 (SQL Overall)1786911237.68923239.8
 
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.