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 “robber” with Change Limit: [1] [2]

(Found more than 100 similar words, so Change Limit cannot be increased.)
to automatically search another random word after seconds.

114 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
robber10391653(None) 
bobber95016741bobber
cobber124116841cobber
dobber114015421dobber
hobber134114631hobber
jobber173813351jobber
lobber104016601lobber
mobber123613461mobber
ribber103515491ribber
robbed113415191robbed
robbers112814161robbers
robbery14348281robbery
rubber104715791rubber
sobber104016591sobber
bibber94613572bibber
bobbed104315832bobbed
bobbers103614282bobbers
bobbery13438352bobbery
bomber125014652bomber
clobber13378162clobber
cobbers134114752cobbers
cobbier133410162cobbier
cobbler133311822cobbler
comber125118502comber
crabber133810732crabber
cribber13367662cribber
dabber114816962dabber
dibber114614712dibber
dobbers123513252dobbers
drabber12438592drabber
drubber12357862drubber
dubber113814552dubber
fabber134814112fabber
fibber134811932fibber
fobbed144112612fobbed
gabber114916602gabber
gibber114112862gibber
gobbed124613882gobbed
gobbet114214442gobbet
gobbler123310022gobbler
goober93911742goober
grabber12389762grabber
grubber12417912grubber
hobbed144114302hobbed
hobbers143512342hobbers
hobbler143710402hobbler
jabber173713642jabber
jibber174111242jibber
jobbed184212132jobbed
jobbers182911132jobbers
jobbery21366012jobbery
libber104414012libber
lobbed113114612lobbed
lobbers113713942lobbers
lobbyer1433912lobbyer
lubber104214622lubber
mobbed137112242mobbed
mobbers133610922mobbers
nabber104913542nabber
nobbier11309162nobbier
nobbler113211182nobbler
nobler83713452nobler
omber95316442_omber
orbier839992orbier
prober104516072pro_ber
rabbet103818652rabbet
rabbler113514092rabbler
rebbe9313162rebbe_
rebbes10313532rebbes
ribbed114014372ribbed
ribbers113913182ribbers
ribbier1137592ribbier
ribier84414232ribier
roamer84715162roamer
roarer63914332roarer
robbin103611182robbin
robe65335642ro_be_
robed85323732ro_bed
robes75133302ro_bes
roble75223022roble_
robles85321692robles
rocker124319572rocker
roger64521412ro_ger
rolfer94412272rolfer
roller63919792roller
romper104213682romper
roofer94415282roofer
roomer84718632roomer
rooser63921882rooser
rooter64926032rooter
roper75431912ro_per
ropier84118802ropier
rosier64221262rosier
roster64329082roster
rotter64325462rotter
rouser65224082rouser
router65025842router
rover85527372ro_ver
rower85430492ro_wer
rozzer1437352rozzer
rubbed114515082rubbed
rubbers113913192rubbers
rubbery14337592rubbery
rubier84814742rubier
slobber11388902slobber
sobbed113516262sobbed
sobbers114114262sobbers
sober74822412so_ber
somber103714002somber
swobber14336542swobber
throbber1543202throbber
tubber104313202tubber
wobbler14329822wobbler
yabber136111832yabber

Search took 3 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 Filter178691825510.1231452772.4
2DLD Change Limit825511142.65631080.9
3Display Results1141140.0333454.5
 (SQL Overall)1786911142.81263545.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.