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

160 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
shaitan103688(None) 
shaitans1136401shaitans
sheitan1036561sheitan
habitan1236902_habitan
seitan62613232s_eitan
shairn9269062shai_rn
shaman113314282sha_man
sheitans1155592sheitans
spartan948332spartan
bhakta1533653bhakta_
bhaktas1633643bhaktas
caftan111710123_caftan
caiman103615663_caiman
captan101613343_captan
chaeta11310683chaeta_
chaetae1238603chaetae
chaetal1238283chaetal
chain105723673chai__n
chainman1585183chainman
chairman15106383chairman
chapman1637893chapman
chasten124312403chasten
chazan20269133cha_zan
chazzan20204853chazzan
chital114313883ch_ital
chitin113114953ch_itin
chiton112612393ch_iton
habitans1346623_habitans
habitant1348673_habitant
habitat12411053_habitat
haika125313793_haika_
hapten115312983_hapten
harijan1735783_harijan
hartal9415473_hartal
hasten95718563_hasten
hazan173813613_ha_zan
hazzan17236803_hazzan
hiatal9310203_hiatal
hitman112710223_h_itman
kaftan13185823_kaftan
paisan84417073_paisan
partan83820563_partan
phaeton1235973phaeton
platan83913693pla_tan
puritan939283puritan
quartan1636423quartan
raita54623073_raita_
raitas64417673_raitas
ratan53722663_ra_tan
rattan63613603_rattan
rhatany1353693rha_tany
sahiwal1344443sahiwal
saiga64717933s_aiga_
saigas74114293s_aigas
saimin8313663s_aimin
sain45551293s_ai__n
saith85826553s_ait_h
saithe94713913s_aithe
saltant7316773s_altant
saltpan935303s_altpan
samaritan1144183samaritan
sampan102511893s_ampan
saran53730303s_a_ran
satang75711563s_a_tang
satay84718463s_a_tay
satin55935213s_a_tin
seaman84015903sea_man
seawan94111223sea_wan
seitans73312303s_eitans
sextan13389643s_extan
shadchan1743053shadchan
shadkhan1942083shadkhan
shaft115725253shaft__
shafted14288803shafted
shafting15278673shafting
shafts125411433shaft_s
shaird10288703shai_rd
shairds11216263shairds
shairns10276783shairns
shaken134113613sha_ken
shalt85534483shalt__
shamans123610903sha_mans
shamas113717943sha_mas
shamisen1344273shamisen
shammas14358723shammas
shantey134210033shantey
shanti94014083shant_i
shantih13309633shantih
shantis103313093shantis
shantung1232733shantung
shanty124715113shant_y
shantyman1762513shantyman
shapen114414653sha_pen
sharia93116723sharia_
shariah132210533shariah
sharias102516003sharias
sharifian1542783sharifian
sharn84823703sha__rn
sharpen12389723sharpen
shat76456593sha_t__
shatter103615693shatter
shaven124213303sha_ven
shawn116417613sha__wn
shazam2046613sha_zam
shebean1235763shebean
sheila969843sheila_
sheilas1059403sheilas
shelta93111783shelta_
sheltas10279663sheltas
shiatsu1033423shiatsu
shiatzu1942893shiatzu
shibah14387473sh_ibah
shiitake1542873shiitake
shikar1336803sh_ikar
shin75634303sh_i__n
shipman14247133shipman
shit76745933sh_it__
shitake1455613sh_itake
shits84731163sh_it_s
shittah1385143shittah
shitty124110053sh_itty
shiva115915003sh_iva_
shivah15488543sh_ivah
shivas124512413sh_ivas
shopman14247253shopman
shoran94016033sh_oran
shorten103511403shorten
shotten10288453shotten
showman15257283showman
shriven13379653shriven
shwanpan1641133shwanpan
sialidan943823sialidan
simian8811163simi_an
simitar936733simitar
sitar54820543s__itar
slain54923573slai__n
smarten9348863smarten
soliton7410233soliton
somital939403somital
spait75631603spait__
spaits85017473spait_s
spatial9310323spatial
spital83813873s_pital
stain55727933stai__n
staithe1037723staithe
statal61613223sta_tal
statant7313123sta_tant
statin63921463sta_tin
station72717243station
straiten838613straiten
sultan63012593s_ultan
suntan62613003s_untan
swagman1334913swagman
swain84919053swai__n
swanpan1243693swanpan
taipan82410663_taipan
tartan64217513_tartan
titan53318173__titan
whiten124111923wh_iten
witan83816503__witan

Search took 9 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.1561145455.1
2DLD Change Limit1340271607.98616782.7
3Display Results1601600.1061509.4
 (SQL Overall)1786911608.24821664.8
 
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.