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

124 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
quibbles213422(None) 
quibble2034711quibble_
quibbled2232721quibbled
quibbler2132841quibbler
quibblers2242451quibblers
bubbles104315962bu_bbles
dibbles124013332_dibbles
dribbles13348392dribbles
fribbles15287712fribbles
gribbles13307362gribbles
kibbles153510252_kibbles
nibbles114011692_nibbles
nubbles113412432nu_bbles
rubbles113715112ru_bbles
squabbles2243632squabbles
audibles11215533audibles
babbles104416323_babbles
bibles104617643_bi_bles
bobbles104514913_bobbles
brabbles11349753brabbles
bubales113513343bu_bales
bubbies103913513bu_bbies
bubble94016593bu_bble_
bubbled113612123bu_bbled
bubbler103611783bu_bbler
bubblers11448943bu_bblers
bubblies1166773bu_bblies
bumbles134016843bu_mbles
burbles114916803bu_rbles
cobbles133814823_cobbles
cribbled15305803cribbled
cubbies133312883cu_bbies
cubicles1435883cubicles
cuittles1045903cuittles
dabbles124514773_dabbles
dibble114013843_dibble_
dibbled133510843_dibbled
dibbler124510283_dibbler
dibblers13377583_dibblers
drabbles13308523drabbles
dribble12368603dribble_
dribbled14376593dribbled
dribbler13316313dribbler
dribblers14274453dribblers
dribblet13347543dribblet
dribblets14294143dribblets
durables11237013durables
edibles1048003edi_bles
fimbles143510663_fimbles
foibles1238853foi_bles
fribble14287783fribble_
fribbled16305743fribbled
fribbler15265953fribbler
fribblers16314193fribblers
fumbles143514413fu_mbles
gabbles124415413_gabbles
gobbles123512583_gobbles
grabbles13339893grabbles
gribble12297273gribble_
guiles73919283gui__les
hobbles143313783_hobbles
hubbies143211563hu_bbies
huipiles1344423huipiles
humbles143215803hu_mbles
jubiles16289373ju_biles
jumbles183013323ju_mbles
kibbes143811193_kibb_es
kibble143910953_kibble_
kibbled16367983_kibbled
mumbles133014433mu_mbles
nibble103713283_nibble_
nibbled12389073_nibbled
nibbler11379273_nibbler
nibblers12306543_nibblers
nobbles114014523_nobbles
nubble103813713nu_bble_
numbles113814273nu_mbles
pebbles1337573_pebbles
qubytes2134383qu_bytes
quezales2643463quezales
quibbling2342823quibbling
quiches2139333qui_ches
quickies2336773quickies
quilled17329283qui_lled
quillet162713233qui_llet
quillets17256823qui_llets
quills153811853qui__lls
quilts154112543qui__lts
quinces183210433qui_nces
quinelas1744933quinelas
quinines172410203quinines
quinols16297243quinol_s
quinones17227753quinones
quinsies1737623quinsies
quintes164114713qui_ntes
quintiles1845983quintiles
quires154015753qui__res
quitches2236193quitches
quixotes2443553quixotes
quizzes2435573qui_zzes
rabbles113517973_rabbles
rubbies114114113ru_bbies
rubble104315673ru_bble_
rubbled124611623ru_bbled
rubles83921703ru__bles
rumbles114018393ru_mbles
scabbles14167983scabbles
scribbles15184953scribbles
squabble2143883squabble_
squabbled2342563squabbled
squabbler2242733squabbler
squabblers2341843squabblers
squibbed2283423squibb_ed
squiggles2052993squiggles
stubbles1236843stubbles
thimbles1536023thimbles
tubules9310233tu_bules
tuilles72411923tui_lles
tumbles113816023tu_mbles
umbles103817493_u_mbles
unbales92914863_unbales
wabbles144013993_wabbles
wimbles143010853_wimbles
wobbles143412433_wobbles

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.423422437.4
2DLD Change Limit1461621246.43622710.1
3Display Results1241240.0462695.7
 (SQL Overall)1786911246.90525878.5
 
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.