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

96 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
wasabis125536(None) 
wasabi1154641wasabi_
casabas1139982casabas
abatis84317933_abatis
alibis8311073_alibis
anabas8314083_anabas
arabic10312733_arabic
asanas6514113_asanas
ascaris93613323_ascaris
aspis74618143_as_pis
assais6711963_assais
basalts9358963basalts
basis75429863bas__is
basmatis1247343basmatis
cannabis1266033cannabis
carabid12311333carabid
carabids1338183carabids
carabin11313213carabin
carabins12312353carabins
casaba1079263casab_a
casas75327843casa__s
casavas1237813casavas
casbahs1436463casbahs
cassabas1245733cassabas
cassis84818853cas_sis
dalasis8810533dalasis
dashis104414393das_his
galabia1038313galabia
galabias1137733galabias
gasbags1135473gasbags
gazabos1944453gazabos
kababs14409763kabab_s
kasbahs1634363kasbahs
lanais6316793lana_is
lassis65216703las_sis
lavabos1235453lavabos
masalas9312053masalas
masas75630413masa__s
mastabas1246803mastabas
nabis76020573__nabis
nasalise848863nasalise
nasalism1048203nasalism
nasals63312463nasa_ls
nawabs1185063nawab_s
oasis56422553oas__is
palais8420423pala_is
pastis84924323pas_tis
piasabas1243883piasabas
rabbis102613153ra_bbis
sabes76437463__sabes
sabin74924943__sabin
sabins85521973__sabins
sabir75916993__sabir
sabirs85414623__sabirs
sabs66643743__sab_s
sadis64930853__sadis
safaris101110663safaris
sakis95323663__sakis
salamis9313513salamis
saris54544953__saris
sassabies1144143sassabies
satis55633673__satis
tabbis102910853ta_bbis
tamaris9413573tamaris
tatamis939713tatamis
tsadis7429133_tsadis
uakaris1146633uakaris
wabs97337233w__ab_s
wadable13310233wadable
wadis95223963w__adis
wakames1635283wakames
wakikis1342623wakikis
wallabies1445733wallabies
wannabes1344473wannabes
wapitis1236473wapitis
warsaws1335763warsa_ws
washable16138043washable
washables17144743washables
washers134517523washers
washes124425493was_hes
washups1534683washups
waspish1586923was_pish
wasps106714693was__ps
wassail1056133wassail
wassails1145953wassails
wastable131410453wastable
wastages12109753wastages
wasters104026593wasters
wastes96224883was_tes
wastrie101210293wastrie
wastries111212883wastries
wasts87433673was__ts
watapes12228383watapes
wataps11248683wata_ps
waxable1937673waxable
weasands1244563weasands

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.1561145455.1
2DLD Change Limit134027966.97019229.1
3Display Results96960.0332909.1
 (SQL Overall)178691967.15924960.3
 
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.