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

261 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
jarrah163668(None) 
jarrahs1735451jarrahs
aarrgh10786302aarrgh
arras55626132_arras
array86317142_array
hurrah12369182hurrah
jagra1338172jagra_
jagras1438462jagras
jarred144613252jarred
marram10313882marram
pardah123412822pardah
pariah114320582pariah
parral85517532parral
sirrah9379752sirrah
aah616252963_a__ah
aargh96314083_aargh
aarrghh141463603aarrghh
airth85621023_airth
almah106917253_almah
amah98927483_a_mah
arak86929573_a_rak
arch98628443_a_rch
area45843393_area_
areae55229743_areae
areal55928733_areal
areas55935773_areas
argal65023383_argal
arhat8327093_arhat
aria46245423_aria_
arias55438023_arias
arrack121110253_arrack
arrant6623253_arrant
arrays95311683_arrays
arrear6310253_arrear
arris56824683_arris
arrow83414883_arrow
artal55525473_artal
arval86017013_arval
aura45836253_aura_
aurae54128113_aurae
aural54428963_aural
aurar54420253_aurar
auras55932553_auras
ayah108022993_a_yah
barbal104016663barbal
barca91319433barca_
barcas101016603barcas
barman103519703barman
barrack1538253barrack
barrage10710843barrage
barre75929543barr_e
barred95725793barred
barrel84517873barrel
barren85317613barren
barres84427543barres
barret84930483barret
barrio8312573barrio
barrow114512763barrow
carat75048793ca_rat
carman103920743carman
carnal83919203carnal
caroach1488863caroach
caroch13911763caroch
carpal103716253carpal
carr65434703carr__
carrack1548753carrack
carrel84718633carrel
carroch1437093carroch
carrom10513403carrom
carrot8423123carrot
carrs75730853carr_s
carry105823783carr_y
carwash1535993carwash
casbah1337903casbah
coprah133710603coprah
corral83616253corral
currach1446453currach
curragh1344293curragh
curran8312023curran
darbar959953darbar
dourah10479813dourah
durra65315793durra_
durras74713373durras
earlap837183earlap
earth85023053ea_rth
earwax1664733earwax
farad95720673fa_rad
farfal123410183farfal
farrago1144923farrago
farrow12309973farrow
galah95917623ga_lah
ganjah17145493ganjah
garda7316763garda_
gardai839663gardai
garish104516923garish
garred85217403garred
garret74426553garret
garron73113493garron
garth94720223ga_rth
gerah9315303_gerah
hallah124115403hallah
halvah15499833halvah
hamzah23135553hamzah
harrow122610773harrow
harry115322953harr_y
harsh116418053ha_rsh
hartal9415473hartal
hijrah1934273hijrah
hoorah124411113hoorah
horah117922043_horah
hurrahs13336773hurrahs
hurray12459913hurray
jacal14313703ja_cal
jackal1937613jackal
jadish17319903jadish
jaguar1435283jaguar
jalap143612473ja_lap
japan14411233ja_pan
jar107646153ja_r__
jarful1646683jarful
jargon1448823jargon
jarhead1835173jarhead
jarina134014063jarina
jarinas143712183jarinas
jarl115828133ja_r_l
jarls126120963ja_rls
jarring153613193jarring
jars117338353ja_r_s
jarvey19135403jarvey
java147316643ja_va_
javas155915423ja_vas
jawan15710383ja_wan
jerrid14259143jerrid
jerry155016183jerr_y
joram145816983j_oram
jordan1468063jordan
jubbah2034353jubbah
jubhah2142803jubhah
jura116024893j_ura_
jural125120483j_ural
jurat124829323j_urat
karat96837593ka_rat
karma113415003karma_
karmas123013733karmas
karroo10410013karroo
kasbah1535183kasbah
labra75415463labra_
larch105919793la_rch
lariat6629043lariat
larrup835713larrup
larva8312483larva_
larvae938843larvae
larval948503larval
larvas9310233larvas
laura54116203laura_
laurae64011663laurae
lauras63414333lauras
madras94316423madras
mara67444563ma_ra_
maras75443283ma_ras
march125622893ma_rch
margay12310593margay
maria75032883maria_
marish114319053marish
marka114620793marka_
markas124717003markas
marrams11310123marrams
marrano939423marrano
marred95421043marred
marrer83716673marrer
marron83717543marron
marrow112812603marrow
marry104821693marr_y
marsh105320853ma_rsh
matsah1138233matsah
matzah2035963matzah
mojarra1642513mojarra_
mojarras1742253mojarras
murra74519083murra_
murras84916003murras
murrha11366453murrha
myrrh1337093myrr_h
naira5314743naira_
nairas6312773nairas
narial6317953narial
narrate7313493narrate
narrow9269143narrow
narwal938943narwal
orra46120723_orra_
para65242173pa_ra_
parae76335703pa_rae
paraph13311263paraph
paras76143043pa_ras
parch125123003pa_rch
pardahs13289673pardahs
pariahs123812343pariahs
parian83223963parian
parish115022353parish
parka115120883parka_
parkas125018023parkas
parlay113713993parlay
parr65731153parr__
parrals94414573parrals
parred95024073parred
parrel84515983parrel
parrot8320663parrot
parrs75928673parr_s
parry105323753parr_y
partan83820563partan
parura8310583parura_
paruras9310533paruras
purdah12288753purdah
rah68052403___rah
rajah155711423ra_jah
rayah116013503ra_yah
sabra75317853sabra_
sabras85116363sabras
sacra74516993sacra_
sacral83414413sacral
saran53730303sa_ran
sardar73013173sardar
sarsar63011843sarsar
satrap86212553satrap
shariah132210533shariah
sirra54416323sirra_
sirrahs10377303sirrahs
sirras63814863sirras
surah86823253_surah
surra55521343surra_
surras65919533surras
tagrag837043tagrag
tarmac10310333tarmac
tarnal63716503tarnal
tarpan82814293tarpan
tarre55825633tarr_e
tarred74720283tarred
tarres64723043tarres
tarry85422513tarr_y
tarsal63315273tarsal
tartan64217513tartan
tartar63214753tartar
tarzan152910753tarzan
terra54419653terra_
terrae62915203terrae
terras63516953terras
torah87125273_torah
vara75530883va_ra_
varas86028193va_ras
varia85824203varia_
varias95019903varias
varna84516173varna_
varnas94212823varnas
wallah124011993wallah
warmth1477933warmth
warpath1545203warpath
warrant10614243warrant
warred104019843warred
warren95012853warren
warsaw1236193warsaw
wirra83210823wirra_
yarrow12287933yarrow

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 Filter1786911127160.1561145455.1
2DLD Change Limit1127162616.78016624.8
3Display Results2612610.0962718.8
 (SQL Overall)1786912617.03225411.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.