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

(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
aikido113547(None) 
aikidos1253881aikidos
amido85720982a_mido
azido155411542a_zido
hapkido1743142hapkido
imido85812242_imido
libido935752libido
mikado1344512mikado
abide86223713a_bide
acid77533393a_cid_
acids87121003a_cids
acidy117214893a_cidy
acrid86920103acrid_
ado49146873a___do
agio57828453a_gi_o
aid49269083a__id_
aide56045003a__ide
aided75828933aided_
aiding84423613aiding
aids57846363a__ids
ailed66240283ailed_
ailing74331013ailing
aimed85626053aimed_
aiming94320843aiming
aired66032923aired_
airier64619363airier
airily93014823airily
airing74927503airing
akimbo1443393akimbo
akin86328033a_ki_n
albedo956123albedo
albino839933albino
alcid85817973alcid_
alcids94812293alcids
algid75415583algid_
alkie95520033alki_e
alkies104518093alkies
alkine104916803alkine
alkyd13537093alkyd_
alkyds14404363alkyds
alnico877943alnico
amid77036353a_mid_
amide86128483a_mide
amidol9489573a_midol
amids85627513a_mids
amigo86515473a_migo
amino75425503a_mino
ammino1069883ammino
amnio75218053amni_o
aphid115515393aphid_
aphids125110843aphids
arid57642713a_rid_
aroid65428343aroid_
aroids75118223aroids
arsino64113513arsino
aside65122083a_side
asked106919313asked_
asking116017233asking
audio62917103audi_o
avid88325963a_vid_
aviso85713963a_viso
avoid95516683avoid_
avoids104410203avoids
azide155617163a_zide
bifid11910703bifid_
biked125320033biked_
bikie113915883biki_e
bikies124515163bikies
biking135018173biking
bikini12418913bikini
daimio937463daimi_o
dido66528203__dido
dikdik1152613dikdik
diked115024683diked_
diking124320243diking
dildo71911773di_ldo
divide113410893divide
fido87726403__fido
finito9310303finito
hairdo1036433hai_rdo
hapkidos1842713hapkidos
hiked135919203hiked_
hiking143617103hiking
imid76122293_imid_
imide85716893_imide
imids86015143_imids
imino74315233_imino
irid55927173_irid_
irids66417773_irids
kid86540623__kid_
kiddo11398953ki_ddo
kids96029643__kids
kilo86028673__kilo
kino86233623__kino
kudo96115113__kudo
libidos1044653libidos
lido56028163__lido
liked104523813liked_
liking114319583liking
lipid85916173lipid_
lipide93511063lipide
lipids94310923lipids
livid96714423livid_
mikados1444683mikados
miked125020453miked_
miking134218463miking
misdo85413183mi_sdo
nitid61817833nitid_
paiked135113433paiked_
paiking143814813paiking
piked125623313piked_
piki106520563piki__
piking133719643piking
pikis115116393piki_s
rigid7913893rigid_
saiyid10167413saiyid_
saiyids11174893saiyids
skid95720933_skid_
skidoo1136093_skidoo
skids104615333_skids
skimo116312543_skimo
tiki87620843tiki__
tikis95615973tiki_s
timid84815733timid_
viking143414613viking
virid94116043virid_
vivid125112313vivid_
wikiup15183533wikiup

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 Filter1786911127160.796224486.2
2DLD Change Limit1127161285.54620323.8
3Display Results1281280.0333878.8
 (SQL Overall)1786911286.37528030.0
 
Comments and Suggestions welcome: FaceBook ~ UserVoice ~ SQLServerCentral  |  Developed By: Tom Keller Consulting © 2011-2025  |  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.