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

128 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
agile6512226(None) 
anile54634461anile
axile126020511axile
vagile10310541vagile
abele76323252abele
abide86223702abide
able66340532a_ble
addle74318352addle
aedile73716652aedile
afire86215912afire
agape85614842agape
agate66525142agate
agave95314032agave
agaze156113662agaze
age47154332ag__e
agee56241492ag_ee
agene65621582agene
aggie73415012aggie
agilely1135122agilely
agin56132712agi_n
aging77026352aging
agio57828452agi_o
agios65919862agios
agism84614062agism
agist66325582agist
agita6315422agita
aglee65728492aglee
aglet65534142ag_let
agley96917332ag_ley
agly86821802ag_ly
agnize16329562agnize
agone65924552agone
agree65226032agree
ague55725922ag_ue
aide56044992a_ide
aiglet74224192aiglet
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
argil65116882argil_
argils75213622argils
argle65421562argle
argyle1066062argyle
ariel55228972ariel
aril45843022aril_
ariled75620322ariled
arils58732202arils
arise56436432arise
aside65122082aside
atilt54828472atilt
audile73315302audile
augite7312612augite
awhile1257792awhile
axil116424452axil_
axils127217502axils
axite125218252axite
axle116424602a_xle
azide155617162azide
azine146721412azine
azole145118032azole
bile66147172_bile
cagily12411562cagily
chile105626892chile
daggle93711902daggle
eagle64219482eag_le
edile64819492edile
exile126117652exile
facile112514882facile
file75446642_file
fragile1147842fragile
gable85325522gable
gaggle93412622gaggle
gaily95020972gaily
gale56347322_gale
gibe75927772_gibe
gie47149542_gi_e
gild65526512_gild
gill56336182_gill
gilt56348542_gilt
gite55438612_gite
give85829352_give
guile64521132guile
habile11515202habile
haggle113511982haggle
labile8315212labile
magilp1137612magilp
maile75232212maile
mile66352562_mile
nargile847652nargile
ogive9379092ogive
ogle56325052og_le
pile65649692_pile
raggle83712882raggle
rile45650532_rile
smile74823912smile
spile75230082spile
stile54931572stile
tile45451442_tile
toile54626492toile
unagile838282unagile
utile54718932utile
vile76139802_vile
voile84719722voile
waggle113612302waggle
while115418692while
wile75944372_wile

Search took 5 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 Limit538001283.73314412.0
3Display Results1281280.0632031.7
 (SQL Overall)1786911283.96945021.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.