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

(Found more than 100 similar words, so Change Limit cannot be increased.)
to automatically search another random word after seconds.

105 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
axile12602051(None) 
agile65122261agile
anile54634461anile
axil116424451axil_
axils127217501axils
axite125218251axite
axle116424601ax_le
exile126117651exile
abaxile1644082abaxile
abele76323252abele
abide86223702abide
able66340532a_ble
addle74318352addle
aedile73716652aedile
afire86215912afire
aide56044992a_ide
ail37171042a_il_
ailed66240282a_iled
ails45654712a_ils
aisle55223192aisle
ale36572342a__le
alible8311972alible
alike95523962alike
aline57243152aline
alive85722512alive
amble95924632amble
amice96122862amice
amide86128472amide
amie66339842ami_e
amine75835372amine
amole75724592amole
ample94720302ample
anele55628832anele
angle64528872angle
anil46437432anil_
anils56326722anils
anime75423202anime
anise55129702anise
ankle95220252ankle
anole55330372anole
apple94517672apple
argle65421562argle
ariel55228972ariel
aril45843022aril_
ariled75620322ariled
arils58732202arils
arise56436432arise
aside65122082aside
atilt54828472atilt
audile73315302audile
awhile1257792awhile
axal116520492axal_
axe108239492ax__e
axel115222072axel_
axels126313632axels
axial124515192axial
axilla13289572axilla
axillae14248232axillae
axing138521372axing
axiom143913592axiom
axion1211316912axion
axis116127912axi_s
axised14438962axised
axises134413992axises
axites134913832axites
axled135315812ax_led
axles125219472ax_les
axlike17388852axlike
axone125918472axone
azide155617162azide
azine146721412azine
azole145118032azole
bile66147172_bile
chile105626892chile
edile64819492edile
exiled144712462exiled
exiler134712182exiler
exiles134816402exiles
exine125518492exine
facile112514882facile
file75446642_file
guile64521132guile
habile11515202habile
ixtle12168012ixtle
labile8315212labile
maile75232212maile
maxixe1435222maxixe
mile66352562_mile
oxide131210952oxide
oxime1498432oxime
pile65649692_pile
rile45650532_rile
smile74823912smile
spile75230082spile
stile54931572stile
taxite13511302taxite
tile45451442_tile
toile54626492toile
utile54718932utile
vagile10310542vagile
vile76139802_vile
voile84719722voile
waxily19218412waxily
while115418692while
wile75944372_wile

Search took 3 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 Filter178691538000.1731032896.0
2DLD Change Limit538001051.81329674.6
3Display Results1051050.0303500.0
 (SQL Overall)1786911052.01688636.4
 
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.