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

100 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
gumball126683(None) 
gumballs1345311gumballs
gimbal11228812gimba_l
gimbals12257822gimbals
gumboil1244372gumboil
jumbal1758462jumba_l
jumbals18106532jumbals
ball66043323___ball
blueball1244783blueball
boxball18155323boxball
bubal94218213bu_ba_l
bubale104014623bu_bale
bubals103513843bu_bals
bumble124216893bumb_le
bummalo1353793bummalo
cembali13156043cembali
cembalo13145533cembalo
cymbal15236913cymba_l
cymbals16236143cymbals
dumbbell1542143dumbbell
dumbly14399603dumb_ly
embalm1236653_embalm
eyeball1245063eyeball
fumble133214263fumb_le
gadwall1244563gadwall
gall56335993g___all
gamba106018513gamba__
gambade1336383gambade
gambado1344973gambado
gambas115817513gamba_s
gamble115417183gamb_le
gambol1138223gamb_ol
gambols1238593gambols
gambrel1235453gambrel
gimbaled14104173gimbaled
gimballed1542673gimballed
gimmal11247513gimma_l
gimmals12225823gimmals
gingall9117333gingall
global937663globa_l
globally1444613globally
goofball1443273goofball
grumble12349233grumb_le
grumbly15355403grumb_ly
gull54828453gu___ll
gumbo104413583gumb__o
gumboils1343893gumboils
gumboot1246493gumboot
gumbos114610873gumb_os
gumbotil1342073gumbotil
gumma105313103gumma__
gummas114810513gumma_s
gummata1244613gummata
gunwale1134733gunwale
humble133615053humb_le
humbly164010523humb_ly
imbalm1246323_imbalm
jumble174012653jumb_le
lowball1275503lowball
lumbago1243833lumbago
lumbar103610593lumba_r
lumbars11289763lumbars
mall64639373__m_all
mumble123614343mumb_le
mumbly15319463mumb_ly
numbat10312083numba_t
numbats1137673numbats
numbly134410663numb_ly
nutgall844443nutgall
oddball1143773oddball
outbawl1237473outbawl
outcall9310123outcall
outfall1039683outfall
pinball1137933pinball
puffball1841983puffball
pushball1543313pushball
rumba93612513rumba__
rumbaed12287493rumbaed
rumbas102512013rumba_s
rumble103718813rumb_le
rumbly134412163rumb_ly
sambal105215183samba_l
sambals115213483sambals
small74016263_sm_all
sourball1045363sourball
tambala1138023tambala
timbal102510753timba_l
timbale11248803timbale
timbals11239533timbals
tombal102311023tomba_l
tubal75517203tu_ba_l
tumble103215643tumb_le
tumbrel11406853tumbrel
tumbril11256403tumbril
tymbal13236823tymba_l
tymbals14265723tymbals
umbel93612843_umb_el
umbels104510593_umbels
umbral1038633_umbral
unbale83616403_unbale

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 Filter1786911340270.1561145455.1
2DLD Change Limit1340271006.37621020.5
3Display Results1001000.0303333.3
 (SQL Overall)1786911006.56227231.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.