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

104 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
shikseh1710260(None) 
shikse1386071shikse_
shiksehs1892091shiksehs
shikses14116571shikses
shikker13277022shikker
shiksa1394652shiks_a
shiksas1484642shiksas
chisel112111943chi_sel
hike116830393_hik_e_
hiked135919203_hik_ed
hiker125119393_hik_er
hikes125426983_hik_es
hirsel9138683_hirsel
hissed104114453_hissed
hisser94713793_hisser
hisses94719353_hisses
mikveh18132543_mikveh
seise54727853sei_se_
seised74218123sei_sed
seiser65318343sei_ser
seises64026713sei_ses
shake124726403shak_e_
shaken134113613shak_en
shaker134319463shak_er
shakes135024593shak_es
shakier143411153shakier
shakoes144510023shakoes
sheesh1237813shees_h
sheikh16206993sheik__h
sheiks132510013sheiks__
shekel1338383shek_el
shibah14387473shi_bah
shicker163914823shicker
shicksa1634103shicks_a
shicksas1743523shicksas
shied96125493shi__ed
shiel811023773shi__el
shier85428943shi__er
shies86136553shi__es
shiest95821533shies_t
shifted14359983shifted
shifter132911083shifter
shikar1336803shik_ar
shikaree1544833shikaree
shikari1444513shikari
shikars1436183shikars
shikkers14326523shikkers
shilled113313623shilled
shimmed15338583shimmed
shimmer143310873shimmer
shims104422553shims__
shine85533093shi_ne_
shined104620783shi_ned
shiner93820873shi_ner
shines95028913shi_nes
shinier104113143shinier
shinned114310913shinned
shinney13368293shinney
shins85131043shins__
shipmen14317283shipmen
shipped153312103shipped
shippen14298863shippen
shipper143514043shipper
ships105123773ships__
shire84727133shi_re_
shires95225573shi_res
shirked153710463shirked
shirker143711343shirker
shirks134814123shirks__
shirred113710503shirred
shist84829613shi_s_t
shists96515113shi_sts
shits84731173shits__
shittah1385153shittah
shitted114212053shitted
shivah15488543shi_vah
shive114423423shi_ve_
shiver124517373shi_ver
shives124921413shi_ves
shivs115018803shivs__
shrike134513243shrik_e_
shrikes144412393shrik_es
shtiks13297833shtiks__
shush113812543sh_us_h
sike87138783s_ik_e_
siker95326033s_ik_er
sikes96236083s_ik_es
sises55233833s_i_ses
sisses64520603s_isses
spike114922843spik_e_
spiked134915553spik_ed
spiker124315663spik_er
spikes124520713spik_es
spikey155411333spik_ey
spikier13369983spikier
spiks114117473spiks__
swish115114823swi_s_h
swisses10417143swisses
thickset17257133thickset
whimsey18373893whimsey
whish144512923whi_s_h
whisked18336913whisked
whisker17367933whisker
whiskey20445583whiskey

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 Filter1786911340270.393454684.5
2DLD Change Limit1340271045.90622693.4
3Display Results1041040.0462260.9
 (SQL Overall)1786911046.34528162.5
 
Comments and Suggestions welcome: FaceBook ~ UserVoice ~ SQLServerCentral  |  Developed By: Tom Keller Consulting © 2011-2025  |  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.