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

278 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
rani4664010(None) 
ani37751171_ani
bani65334951bani
ragi56032281ragi
rai37658221ra_i
rain46251731rain
raki87127831raki
rami66034091rami
ran38266611ran_
rand55839561rand
rang56939151rang
ranid66429331ranid
ranis55235831ranis
rank85135521rank
rant45864671rant
ahi68040232_ahi
ai211288392_a_i
ain37579092_ain
ami56646812_ami
an211879072_an_
ana39559822_ana
and47244162_and
ane37866942_ane
anil46437432_anil
anis45746462_anis
ant37270782_ant
anti45536362_anti
any68440482_any
ban58366832ban_
band76740902band
bane65250422bane
bang74836992bang
bank105835742bank
bans66555132bans
brain76229382brain
bran65740382bran_
brand85124492brand
brank115222282brank
brans75437432brans
brant74742172brant
bravi104715752bravi
cadi75732172cadi
cain65643912cain
can57760132can_
cane66653112cane
canid85526342canid
cans65050842cans
cant66362022cant
coni65534802coni
crane75331602crane
crania82418432crania
crank114819612crank
dan46859662dan_
dang65131532dang
danio6319782danio
dank95828232dank
dans56748142dans
deni56929392deni
drain65222892drain
drank104816202drank
fain75840562fain
fan67158852fan_
fane75343562fane
fang85432542fang
fano75831682fano
fans76247362fans
franc104615412franc
frank124417512frank
gadi66329722gadi
gain56042162gain
gan48060122gan_
gane55145292gane
gang66031962gang
garni6315702garni
grain65126252grain
gran56335012gran_
grana65722092grana
grand75122692grand
grans64832542grans
grant64840022grant
haji148520182haji
hand86833702hand
hang85535542hang
hank115134132hank
hant75461582hant
jane115031472jane
kadi96224822kadi
kain85334292kain
kaki76520912kaki
kami105823642kami
kana85928522kana
kane85133962kane
kanji1647452kanji
lain46146282lain
lanai5319572lanai
land56337302land
lane45153322lane
lang56637372lang
lank84734442lank
lari45839152lari
lati46438272lati
magi76329522magi
main65345512main
man57465852man_
mana65341942mana
mane65052012mane
mania75634142mania
manic94629432manic
mano66536792mano
mans66354532mans
many95731842many
maxi137023552maxi
mini65634552mini
muni65824402muni
nan37854872nan_
nana46632892nana
nans46139392nans
naoi46024632naoi
nazi136219872nazi
orang65119942orang
padi76331782padi
pain65647242pain
pan58466442pan_
pane64950282pane
pang75336282pang
panic93923902panic
pans65855722pans
pant66061252pant
prang84820322prang
prank115019452prank
qadi145621102qadi
rabbi93113182rabbi
rabic93817402rabic
rabid84520782rabid
race66746262race
rack106234882rack
racy95825682racy
rad47662002ra_d
radii64016412radii
radio64922492radio
radix134414592radix
rads56046602rads
raff104933042raff
raft76245912raft
rag45761322ra_g
raga55930812raga
rage55742352rage
ragg65622692ragg
ragis66325602ragis
rags55448372rags
rah68052402ra_h
raia46638382raia
raid55243072raid
rail46147762rail
rains55140232rains
rainy85921082rainy
rais45252622rais
raj105740222ra_j
raja117918682raja
rake84841572rake
rakis95323442rakis
raku85423772raku
rale45050562rale
ram56867272ra_m
ramie75027822ramie
ramp85934002ramp
rams65950772rams
rance75028512rance
ranch105019792ranch
rancid9513862rancid
rands65930452rands
randy95022082randy
ranee55438102ranee
range64728412range
rangy95320382rangy
ranids75118702ranids
ranks95225732ranks
rants55935342rants
rap56261962ra_p
rape65041632rape
rapid86422032rapid
rapini84714682rapini
raps66247732raps
rapt67245312rapt
rare45348432rare
ras37575392ra_s
rase46149982rase
rash76039932rash
rasp66029162rasp
rat37892742ra_t
rate45458762rate
rath76037662rath
ratio55227582ratio
rato45436972rato
rats46260372rats
rave75542092rave
ravin85624652ravin
raw67252252ra_w
rawin85521472rawin
raws75238212raws
rax108445722ra_x
ray66361992ra_y
raya75224822raya
rays77642352rays
raze135235432raze
razz125219422razz
rei35647252r_ei
rein46040892rein
rend56136572rend
renig64518912renig
renin54830032renin
rent46661242rent
riant55833152riant
rin36663182rin_
rind56535602rind
ring56541152ring
rink87736992rink
rins46153192rins
roan47234202roan_
roans54926442roans
roti46332922roti
ruana5312422ruana
ruin47430512ruin
run36244982run_
rune45236292rune
rung56429972rung
runic73615772runic
runs46438072runs
runt46647982runt
rynd86414102rynd
sadi55834642sadi
sain45551292sain
saki85628472saki
sand55338462sand
sane45954332sane
sang55441222sang
sank85236822sank
sans45153352sans
sari45444042sari
sati45539322sati
tain45548072tain
tali46837162tali
tan37167562tan_
tang56138662tang
tank85134012tank
tans46154812tans
taxi117124762taxi
tragi64717172tragi
train56529112train
trank96222422trank
tranq145416892tranq
trans54933042trans
unai44824782unai
uraei53016082uraei
urania62516122urania
uranic82315182uranic
urari54619962urari
vagi86719362vagi
vain75233002vain
van66246322van_
vane75534682vane
vang84926032vang
vans76236722vans
wadi86228172wadi
wain75840192wain
wan66761932wan_
wand85833872wand
wane76344712wane
wank115632502wank
wans76452262wans
want76156162want
wany106432352wany
wrang94716112wrang
yagi86922242yagi
yang85626062yang
yank115423662yank
yoni77524392yoni
zany167316982zany

Search took 4 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 Filter178691298720.220812231.8
2DLD Change Limit298722782.43612262.7
3Display Results2782780.1262206.3
 (SQL Overall)1786912782.78264231.1
 
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.