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

245 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
sirrah937975(None) 
sirra54416321sirra_
sirrahs10377301sirrahs
sirras63814861sirras
hijrah1934272hijrah
hurrah12369182hurrah
jarrah1636682jarrah
sierra637312sierra_
sierran737192sierran
sierras737862sierras
sirdar7269102sirdar
sirree64017332sirree
surah86823252s_urah
surra55521342surra_
surras65919532surras
wirra83210822wirra_
aarrgh10786303aarrgh
airbag956963airbag
airman82414223airman
airth85621023ai_rth
airway1237693airway
arras55626133_arras
array86317143_array
bimah127013263bi_mah
birch124914023bi_rch
birr66022363birr__
birred94713203birred
birrs74917103birr_s
birth105619873bi_rth
circa9311403circa_
cirrate92413483cirrate
cirri7710723cirr_i
cirrus8349173cirrus
citral81113883citral
coprah133710603coprah
corral83616253corral
currach1446453currach
curragh1344293curragh
curran8312023curran
digraph14146633digraph
diram84419473di_ram
dirham12378273dirham
dourah10479813dourah
durra65315793durra_
durras74713373durras
firman112211343firman
firry115713533firr_y
firth115819533fi_rth
gerah9315303_gerah
girsh95310023gi_rsh
girth95618843gi_rth
hijra1535643hijra_
hijrahs2043443hijrahs
hijras1635773hijras
hoorah124411113hoorah
horah117922043_horah
hurrahs13336773hurrahs
hurray12459913hurray
ihram10310183_ihram
irreal657823_irreal
jarrahs1735453jarrahs
khirkah1641423khirkah
kiblah1535583kiblah
kirsch1532713kirsch
libra74712423libra_
librae84310173librae
libras83711703libras
lira46928683li_ra_
liras56021983li_ras
liroth938383liroth
marram10313883marram
micra96214973micra_
midrash1335423midrash
mihrab1335523mihrab
mikra114610313mikra_
mikvah18143473mikvah
mirror848003mirror
mirth106418893mi_rth
mirza16410443mirza_
mirzas1738173mirzas
mitral81314323mitral
murra74519083murra_
murras84916003murras
murrha11366453murrha
myrrh1337093myrr_h
orra46120723_orra_
pardah123412823pardah
pariah114320583pariah
parral85517533parral
purdah12288753purdah
rah68052403___rah
ricrac1037013ricrac
riprap1055513riprap
sabra75317853sabra_
sabras85116363sabras
sacra74516993sacra_
sacral83414413sacral
saran53730303s_aran
sardar73013173sardar
sarsar63011843sarsar
satrap86212553satrap
scarab10310063scarab
scarph13429603scarph
scirrhi1242293scirrhi
scorch13198093scorch
scrag85916173s_crag
scram910621613s_cram
scrap97120403s_crap
screak125311053screak
scream104814243scream
search113312423search
selah8319613s_elah
sera46141393s_era_
serac75925203s_erac
serai56830163s_erai
seral56336383s_eral
seraph114011163seraph
serdab937833serdab
serial64625853serial
serrano768453serrano
serrate73017533serrate
serry84824123serr_y
serval93913413serval
shah105627783s__hah
shariah132210533shariah
shibah14387463shibah
shirr84716923shirr__
shirred113710493shirred
shirrs94413173shirr_s
shittah1385133shittah
shivah15488533shivah
shoran94016033shoran
sial45938833si__al
siccan1037593siccan
sidh86222983si__dh
sigh85625893si__gh
sigla64515203sigla_
sigma84513823sigma_
sigmas94111353sigmas
signa66114703signa_
signal73711483signal
sika86021323si_ka_
sikas94617023si_kas
silva82714023silva_
silvae92811093silvae
silvan92810153silvan
silvas92912183silvas
sima64730783si_ma_
simar74920813si_mar
simars84916933simars
simas75727553si_mas
simian8811163simian
sinh76238043si__nh
sir35746673si_r__
sirdars8228213sirdars
sire46150413si_r_e
sired66134283si_red
siree55238813si_ree
sirees64624583sirees
siren54525823si_ren
sirens65318153sirens
sires55945373si_res
siring75128313siring
sirrees73410563sirrees
sirs44338333si_r_s
sirup74014913si_rup
sirups83710533sirups
sirupy11377053sirupy
sisal54217733si_sal
sistra639333sistra_
sitar54820543si_tar
sitars65417593sitars
sith75435153si__th
sixth155512233si_xth
sizar145214993si_zar
sizars154812623sizars
skirr94810543skirr__
skirred12347073skirred
skirret11278163skirret
skirrs10448193skirr_s
smirch1356463smirch
sora45746913s_ora_
soras55041013s_oras
sororal7310653sororal
sorrel6413543sorrel
sorrow9339443sorrow
sorry84618253sorr_y
sorta57125413sorta_
sovran937153sovran
spiral83715343spiral
spirea84015633spirea_
spireas94412513spireas
sporal82915453sporal
sporran936743sporran
sprag86418693s_prag
sprat76635973s_prat
spray106720063s_pray
spread9312533spread
starch113013203starch
stirred8359693stirred
stirrer7338223stirrer
stirrup943003stirrup
storax1389783storax
strap77925263s_trap
strath93216363strath
straw813321293s_traw
stray88525573s_tray
streak104613623streak
stream84717283stream
stria55723203stria_
striae65422273striae
styrax1675243styrax
subah106015213s_ubah
succah1336643succah
sukkah12123733sukkah
sunnah9369353sunnah
sunray9310123sunray
supra73614253supra_
sura45740293s_ura_
surahs94515543s_urahs
sural55931263s_ural
suras55336323s_uras
surreal739223surreal
surrey94414573surrey
surtax1337843surtax
sutra54217933sutra_
sutras64818583sutras
svaraj1634963svaraj
swaraj1636023swaraj
swarth126012083swarth
terra54419653terra_
terrae62915203terrae
terras63516953terras
tiara5315903tiara_
tiaras6314533tiaras
torah87125273_torah
viral86419593vi_ral
virga9310253virga_
virgas1048883virgas
yirr76513573yirr__
yirred10426963yirred
yirrs8469193yirr_s
yirth116513753yi_rth
zillah1836563zillah
ziram163912893zi_ram

Search took 7 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.1401276364.3
2DLD Change Limit1127162456.08018538.8
3Display Results2452450.1102227.3
 (SQL Overall)1786912456.33028229.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.