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

191 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
tahsils103505(None) 
tahsil936341tahsil_
basils85717472ba_sils
tails55634192ta__ils
tansies74521242tansies
tarsals72512602tarsals
tarsias74013372tarsias
tassels74510852tassels
tassies74918932tassies
tonsils7310182tonsils
abseils935973_abseils
ahis76135383_ah_i_s
ails45654713_a__ils
anils56326723_a_nils
anvils9219713_anvils
apsis75718293_apsi_s
argils75213623_argils
arils58732203_a_rils
arsis55722423_arsi_s
assails769093_assails
assoils776663_assoils
avails939693_avails
axils127217503_a_xils
bails75933523ba__ils
basics104915123ba_sics
basil75122273ba_sil_
basins85722763ba_sins
basis75429863ba_si_s
brasils9410973brasils
camails11311753camails
capsids1239333capsids
cassias93514343cassias
cassis84818853cassi_s
causals91411183causals
cavils114014393ca_vils
dahlias1135723dahlias
dahls95012283dah__ls
daisies84217093daisies
damsels10126703damsels
dashis104414393dashi_s
dassies84418663dassies
dossils8669773dossils
easels65914553ea_sels
easies64126633ea_sies
easily9313023ea_sily
fails85631483fa__ils
falsies103515013falsies
fossils10379013fossils
fusils93912343_fusils
gassily1137813gassily
hails85231643__hails
hansels104011653hansels
hassels104311013hassels
heils85222193__heils
jails125422943ja__ils
jassids1586143jassids
kails95525213ka__ils
kamsins1346963kamsins
lashins103915153lashins
lassies74420103lassies
lassis65216703lassi_s
mails76037783ma__ils
mashies12318253mashies
massifs1237743massifs
nails55730403na__ils
nasals63312463na_sals
nihils937573nih_ils
oasis56422553oa_si_s
pails75833063pa__ils
palsies94420273palsies
pansies94521983pansies
passels93913023passels
pastils94416173pastils
patsies93919483patsies
pensils92811593pensils
phasis114614923phasi_s
rails55937403ra__ils
raisins72715343raisins
ramtils938413ramtils
sahibs1137083sah_ibs
sails55738103sa__ils
sasins64923103sa_sins
sassies74719263sassies
sassily1038723sassily
stasis63116873sta_si_s
staysails1242853staysails
tabbies112913503tabbies
tabbis102910863tabbi_s
tabulis938833tabulis
tachisms1567143tachisms
tachists1348183tachists
tackily1637503tackily
tactics1149323tactics
tactile9310613tactile
taels56822073ta__els
taenias7311283taenias
taffias13377413taffias
taffies133012693taffies
tafias93111963ta_fias
tahini939893tah_ini
tahinis1048013tahinis
tahrs85412333tah__rs
tahsildar135883tahsildar
tahsildars145723tahsildars
tail45443653ta__il_
tains54936323ta__ins
takins105117403ta_kins
talkies113415733talkies
tallies73624603tallies
tallis63319963talli_s
tallits73215993tallits
tallols73311363tallols
talls55133433ta__lls
tamals84116633ta_mals
tameins9311423tameins
tamis76728733ta_mi_s
tamises92715973tamises
tammies113814683tammies
tanists7313653tanists
tannins72813223tannins
tapirs84113173ta_pirs
tapis75028863ta_pi_s
tapises92914013tapises
tardies84225863tardies
tardily11269583tardily
tarries73324263tarries
tarsal63315273tarsal_
tarsi55222173tarsi__
tarsia65514273tarsi_a
tarsier74119253tarsier
tarsiers8298533tarsiers
tarsus6310513tars_us
tartily103511573tartily
tasks94917583ta_s_ks
tass45640573ta_s__s
tassel66014773tassel_
tasses64826763ta_sses
tassets75012773tassets
tassie66017023tassi_e
tastes64126423ta_stes
tastily103311643tastily
tatsois748373tatsois
tatties74120343tatties
tattily10409993tattily
tawnies102812503tawnies
tawnily1335443tawnily
tawpies12309873tawpies
tawses94913193taws_es
tawsing1138673tawsing
taxies135817333ta_xies
taxis126821973ta_xi_s
taxols13328633ta_xols
teasels74311313teasels
tenails73713923tenails
tensile72612733tensile
theins95015423t_heins
theirs94610353t_heirs
thesis94913733thesi_s
thill85918733t_h_ill
thills95515383t_hills
thins85826333t_h_ins
thiols95112763t_hiols
thirls95012063t_hirls
this76027383t_h_i_s
thrill94910593t_hrill
thrills10398783t_hrills
thrips11299013t_hrips
thurls9418713t_hurls
tils45739613t___ils
tinsels738373tinsels
tipsily1236043tipsily
tmesis8529793tmesi_s
tocsins939963tocsins
toils54527493t__oils
tonsil6311873tonsil_
topsails1075093topsails
topsoils1095143topsoils
trails64622513t_rails
transits8313503transits
trashily1437323trashily
travails1146083travails
trysails1144163trysails
tushies10312163tushies
tussis6379953tussi_s
twibils1253113twibils
utensils8124963utensils
vails85825933va__ils
vakils1337593va_kils
vassals1057953vassals
wails86631483wa__ils
wassails1145953wassails

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 Filter1786911340270.440406115.9
2DLD Change Limit1340271916.95019284.5
3Display Results1911910.0633031.7
 (SQL Overall)1786911917.45323975.7
 
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.