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

130 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
rabbiter123467(None) 
rabbited1334761rabbited
rabbiters1343731rabbiters
arbiter939932_arbiter
crabbier14326802crabbi_er
gabbier12379632gabbi_er
grabbier13316652grabbi_er
rabbeted1334442rabbeted
rabbies113416052rabbi_es
rabbit102914552rabbit__
rabbitry15243382rabbitry
rabbits11299862rabbit_s
rabbity14266302rabbit_y
rabbler113514092rabb_ler
ribbier1137582ribbi_er
abater85518123_a_bater
abetter958323_abetter
abider95314463_a_bider
aborter939923_aborter
abutter957513_abutter
albite8313303_albite_
albites9313203_albites
arbiters1038853_arbiters
awaiter1057443_awaiter
babbitry14273073babbitry
babbitt1038033babbit_t
babbitted1342953babbitted
babbittry1551583babbittry
babbitts1144023babbitts
babbler104012823babb_ler
babier103515563ba_bi_er
backbiter191786803backbiter
baiter84422553__baiter
biter75030033___biter
brabbler11397373brabb_ler
cabbie122913343cabbi_e_
cabbies133115163cabbi_es
cobbier133410163cobbi_er
crabber133810733crabb__er
crabeater1345593crabeater
dabber114816963dabb__er
dabbler124012153dabb_ler
dabster1036703da_bster
daubier1037093daubi_er
drabber12438593drabb__er
fabber134814113fabb__er
flabbier1534093flabbi_er
gabber114916603gabb__er
gabbler124013303gabb_ler
gaiter73819503ga__iter
gambier124711963gambi_er
grabber12389763grabb__er
grabbler13377693grabb_ler
grubbier13344753grubbi_er
habited1337883ha_bited
jabber173713643jabb__er
jabberer1944023jabberer
kibbitzer2651243kibbitzer
lambier113611633lambi_er
nabber104913543nabb__er
nailbiter1142673nailbiter
nobbier11309163nobbi_er
nubbier11308133nubbi_er
orbiter937853_orbiter
rabbet103818653rabb__et
rabbets11279423rabbet_s
rabbi93113173rabbi___
rabbin103112293rabbi__n
rabbinate1345143rabbinate_
rabbinates1444513rabbinates
rabbinic1443123rabbinic
rabbins112811343rabbi_ns
rabbis102613153rabbi__s
rabbiting1445033rabbiting
rabbitries1443333rabbitries
rabble103818243rabb_le_
rabbled123514423rabb_led
rabblers123810853rabb_lers
rabbles113517973rabb_les
rabies85226013ra_bi_es
racier85120973ra_ci_er
rafter94517583ra__fter
raider74318743ra__ider
railer64524933ra__iler
rainier71614253raini_er
raiser66620103ra__iser
rallier73816273ralli_er
rambler113313263ramb_ler
rammier112811023rammi_er
randier83618473randi_er
rangier83714353rangi_er
ranter63826823ra__nter
rapider1067903ra_pider
rapier84019993ra_pi_er
raspier93110633raspi_er
raster64731443ra__ster
rater54943283ra___ter
ratite65022423ra_tite_
ratites74920683ra_tites
ratter64326313ra__tter
rattier74015593ratti_er
rebaited11410543rebaited
rebater93517903r_ebater
rebutter10106273rebutter
reciter94117263r_eciter
redbaiter1244153redbaiter
requiter17168643requiter
reuniter838323reuniter
rewriter1137923rewriter
ribber103515493ribb__er
ribier84414223r_ibi_er
robber103916533robb__er
robuster1035663robuster
rubber104715793rubb__er
rubbies114114113rubbi_es
rubblier1244913rubblier
rubier84814733r_ubi_er
scabbier1435133scabbi_er
shabbier1535183shabbi_er
tabbied12297793tabbi_ed
tabbies112913503tabbi_es
tabbises12236523tabbises
tubbier11237743tubbi_er
wabbler143511923wabb_ler
wabblier15375493wabblier
waiter94321253wa__iter
webbier1445423webbi_er
yabber136111833yabb__er
yabbie13308653yabbi_e_
yabbies14279643yabbi_es

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 Filter1786911461620.1561145455.1
2DLD Change Limit1461621307.33019940.2
3Display Results1301300.0462826.1
 (SQL Overall)1786911307.53223724.2
 
Comments and Suggestions welcome: FaceBook ~ UserVoice ~ SQLServerCentral  |  Developed By: Tom Keller Consulting © 2011-2024  |  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.