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 “zoisites” with Change Limit: [1] [2] [3] [4]

You can choose a higher Change Limit to return more words, although it will take longer.
to automatically increase the Change Limit after seconds.

95 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
zoisites174497(None) 
zoisite1635831zoisite_
coesites101313092coesites
amosites10311233amosites
bhisties1339003bhisties
biotites10310083biotites
boites84322703bo__ites
bornites10310973bornites
bossies94116833bossi_es
coesite9713623coesite_
cordites11314603cordites
cosies84932153co_si_es
cosines94122673co_sines
cowrites133011593cowrites
crinites10612753crinites
cuisines1049373cuisines
daisies84217093daisi_es
diorites9313523diorites
doilies84017363doili_es
eosines73718293eo_sines
felsites1138073felsites
finites10315923_finites
foisted113210603fois_ted
foists95413983fois_t_s
fomites123613203fo_mites
gobshites1542933gobshites
gothites1246013gothites
hessites1138613hessites
hoises94823673hois__es
hoisted113411293hois_ted
hoister103714203hois_ter
hoisters113513473hois_ters
hoists95516023hois_t_s
homesites1448913homesites
hoplites13310543hoplites
horstes104516113hors_tes
inosites8312793inosites
iolites73819483io_lites
joisted15379173jois_ted
joists134711033jois_t_s
kainites1238793kainites
lewisites1244213lewisites
limites92915453_limites
miscites12313783_miscites
modistes1138643modis_tes
moieties10311263moieties
moisten93110143mois_ten
moistens10268773mois_tens
moister94015373mois_ter
moistest1038763mois_test
niobites1037313niobites
noesises838503noesises
noises65021853nois__es
noisettes946533noisettes
noisier759453noisi_er
noisiest839763noisi_est
noisiness948343noisiness
norites74018803no_rites
oolites72817843_oolites
ophites12310103_ophites
pinites9319533_pinites
piosities11311723piosities
pistes85325633_pis_tes
podites103014733po_dites
poesies93217403poesi_es
pointes93216753poi_ntes
poises84226543pois__es
popsies112816463popsi_es
posies84431433po_si_es
posited10511493po_sited
posits85718713po_sit_s
posties93128813po_sties
potsies93019483potsi_es
resites74027793_resites
roister73516203rois_ter
roisters83615543rois_ters
sites56045433___sites
somites94219113so_mites
sopites93817173so_pites
sorites73825243so_rites
stipites1039653stipites
subsites10312763subsites
topsides1137203topsides
troilites948433troilites
visited1168773_visited
visiter1038863_visiter
visiters1137403_visiters
visits9311423_visit_s
websites1335183websites
zeolites1738383zeolites
zincites1946633zincites
zombies2037993zombi_es
zoster153715853zo_s_ter
zosters163015403zo_s_ters
zoysias1943843zoysi_as

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 Filter1786911461620.1731032896.0
2DLD Change Limit146162956.09323988.5
3Display Results95950.0303166.7
 (SQL Overall)178691956.29628381.7
 
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.