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

89 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
abaxile164408(None) 
abaxial1646182abaxial
axile126020512__axile
abaci94718843abaci__
abalone938893abalone
abase76023483aba__se
abasia8712953abasi_a
abasias9711013abasias
abasing10610673abasing
abatable1238023abatable
abate76627843aba__te
abating10413973abating
abatis84317933abati_s
abatises10311013abatises
abele76323253ab__ele
abide86223713ab__ide
ablative1348243ablative
able66340533ab___le
aboil72217543ab_oil_
abrasive1345753abrasive
abscise1145953abscise
abseil837183abseil_
abseiled1144733abseiled
abseils935973abseils
abubble1044523abubble
abusive1245283abusive
acarine9316003acarine
adaxial1545323adaxial
aedile73716653a_edile
agatize1739833agatize
agile65122263__agile
alanine7316863alanine
alexine142410543alexine
amative12311733amative
anile54634463__anile
apatite9312963apatite
arabize1849343arabize
arable81821003ara_ble
ataxia13179593ataxi_a
ataxias14189343ataxias
ataxic15169203ataxi_c
ataxics16196643ataxics
ataxies142410013ataxies
audile73315303a_udile
avail8313883ava_il_
availed1135973ava_iled
avails939693ava_ils
avarice1238033avarice
awhile1257793a_while
axil116424453__axil_
axils127217503__axils
axite125218253__axite
axle116424603__ax_le
babble94017113_babble
baffle14399873_baffle
bail65042803_ba_il_
bailed94726653_ba_iled
bailee84526013_ba_ilee
bailer85425253_ba_iler
bailey115015673_ba_iley
bailie83818363_ba_ilie
bails75933523_ba_ils
baize164717393_ba_ize
bale66353843_ba__le
bangle94018953_bangle
barite84224813_barite
basil75122273_basil_
basils85717473_basils
bastile9313913bastile
battle85217863_battle
bauble103813213_bauble
bauxite1635573bauxite
bile66147183_b__ile
boxily1877843_boxily
exile126117653__exile
facile112514883_facile
flexile1735073flexile
fragile1147843fragile
gracile102512603gracile
habile11515213_habile
labile8315223_labile
maile75232223_ma_ile
maxixe1435223_maxixe
saxatile1544953saxatile
stabile9312063stabile
taxite13511303_taxite
unagile838283unagile
vagile10310543_vagile
waxily19218413_waxily

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.1401276364.3
2DLD Change Limit134027897.59317651.4
3Display Results89890.0165562.5
 (SQL Overall)178691897.74923059.9
 
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.