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

152 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
rabbity1426630(None) 
rabbit102914561rabbit_
rabbitry15243381rabbitry
rabbits11299861rabbits
babbitry14273072babbitry
babbitt1038032babbitt
crabbily1744342crabbily
rabbet103818652rabbet_
rabbets11279422rabbets
rabbi93113182rabbi__
rabbies113416052rabbies
rabbin103112302rabbi_n
rabbins112811342rabbins
rabbis102613162rabbi_s
rabbited1334762rabbited
rabbiter1234672rabbiter
rabidity1446582rabidity
rarity93615492ra_rity
raucity1235852raucity
abbacy1536623_abbacy
abbey125714933_abb_ey
abbot9318453_abbot_
abbotcy1642093_abbotcy
abbots1039283_abbots
ability12311443_ability
acuity1139373_acuity
albite8313313_albite
ambit94223713_ambit_
ambits103713413_ambits
amity10416093_a_mity
arability14411013arability
aridity11510113aridity
babbittry1551583babbittry
babbitts1144023babbitts
cabbagy1744013cabbagy
cabbie122913353cabbi_e
cabbies133115163cabbies
cabbing143613153cabbing
cabby145314563cabb__y
cavity14310013ca_vity
crabbier14326803crabbier
crabbing15287933crabbing
crabby15346753crabb__y
dabbing133511233dabbing
dacoity1366183dacoity
dakoity1543423dakoity
drabbet12319573drabbet_
drabbets13294823drabbets
drabbing14286803drabbing
falsity1335903falsity
fatuity1336043fatuity
flabbily1843353flabbily
gabbier12379633gabbier
gabbing133512033gabbing
gabby135512953gabb__y
gambit114714213gambit_
gambits12399723gambits
gaseity1135113gaseity
grabbier13316653grabbier
grabbing14267313grabbing
grabby14336183grabb__y
gratuity1244283gratuity
gravity1437183gra_vity
grubbily1642973grubbily
habit103027023ha_bit_
habits113014653ha_bits
hobbit132810543hobbit_
hobbits14317553hobbits
jabbing19319413jabbing
kibbitz2443953kibbitz
lability13710833lability
laity85318903la__ity
laxity1637273la_xity
nabbing12299963nabbing
nobbily1436693nobbily
orality101111683ora_lity
parity114719873pa_rity
paucity1435823paucity
probity14299683probity
rabat72832223ra_bat_
rabato83413263ra_bato
rabats83116223ra_bats
rabbeted1334443rabbeted
rabbinate1345143rabbinate
rabbinic1443123rabbinic
rabbiters1343733rabbiters
rabbiting1445033rabbiting
rabble103818243rabb_le
rabbled123514423rabbled
rabbler113514093rabbler
rabbles113517973rabbles
rabbling13239333rabbling
rabboni1144803rabboni
rabic93817403ra_bi_c
rabid84520783ra_bi_d
rabidly1336253rabidly
rabies85226023ra_bies
racily11715173ra_cily
rackety16499113rackety
rainily10310433rainily
rainy85921083ra__iny
raisiny10319923raisiny
raita54623073ra__ita
ramify14268753ra_mify
ramosity1345893ramosity
rapacity1544983rapacity
rapidity1446273rapidity
rarebit948423rarebit_
rarebits1045223rarebits
rarify123210063ra_rify
ratify122610043ra_tify
ratite65022423ra_tite
ratty84819593ra__tty
reality10313573reality
rebait8320403rebait_
rebaits9312573rebaits
ribbier1137593ribbier
ribbing123111953ribbing
ribbony1443543ribbony
ribby12419683ribb__y
robbery14348283robbery
robbin103611183robbi_n
robbing123313213robbing
robbins112811063robbins
rubbery14337593rubbery
rubbies114114113rubbies
rubbing123412273rubbing
rubbish1436303rubbish
rubbishy1842153rubbishy
rubbly133710613rubb_ly
rubby124413863rubb__y
sabbat10314713sabbat_
sabbath1445393sabbath
sabbats1138633sabbats
sabbing123314743sabbing
sanity9316203sa_nity
scabbily1763943scabbily
shabbily1873903shabbily
tabbied12297793tabbied
tabbies112913503tabbies
tabbing123611913tabbing
tabbis102910863tabbi_s
tabby125213893tabb__y
urbanity13105303urbanity
vacuity1545763vacuity
vanity12311933va_nity
varsity1356673varsity
vastity1336203vastity
wabbly16348363wabb_ly
yabbie13308663yabbi_e
yabbies14279643yabbies
yabby15389753yabb__y

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 Filter1786911340270.390458182.1
2DLD Change Limit1340271527.06318975.9
3Display Results1521520.0602533.3
 (SQL Overall)1786911527.51323784.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.