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

132 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
daimyo123319(None) 
daimio937461daimio
daimyos1342811daimyos
daily95922332daily_
daimen92210572daimen
daimios1035752daimios
daimon9259712daimon
dairy97016302dairy_
daisy95915312daisy_
abmho1236793_abmho
aim57858213_aim__
aimed85626053_aimed
aimer75926823_aimer
aims67738183_aim_s
airy75734153_airy_
akimbo1443393akimbo
ambo88225143_a_mbo
amido85720983_amido
amigo86515473_amigo
amino75425503_amino
ammo85520133_a_mmo
amyl95515103_a_myl
army96624183_army_
balmy125217473balmy_
barmy125218763barmy_
bimbo114811873_bimbo
blimy125212823blimy_
caiman103615663caiman
cameo95924993ca_meo
camo85731753ca_m_o
campo115219763ca_mpo
dactyl1234983dactyl
daddy116212563daddy_
dado67126333da__do
daemon9279593daemon
daffy155510283daffy_
dago65725093da__go
daiker115113033daiker
daikon11217243daikon
daimons10249323daimons
dainty105311473dainty
dais57040703dai__s
daises74318983daises
dally95324743dally_
dam67457043da_m__
daman84821163da_man
damar84117733da_mar
dame77140313da_m_e
dames85435853da_mes
dammar11438903dammar
dammed124214793dammed
dammer114317933dammer
dammit11311133dammit
damn75724323da_m_n
damns84916923da_mns
damp96228843da_m_p
damps105220413da_mps
dams77444373da_m_s
damson938063da_mson
dandy104416703dandy_
danio6319783da_nio
darky136018833darky_
dashy125612383dashy_
dato56129943da__to
datto65416423da_tto
dauby115211223dauby_
davy116015523da_vy_
day76254113da__y_
days87637133da__ys
deify124112763deify_
deity94316773deity_
demo77427553d_em_o
demy105422853d_emy_
diamin9312523diamin
diary95016973diary_
diazo15310033d_iazo
dido66528203d_i_do
didy99121513d_idy_
dildo71911773d_ildo
dim68146493d_im__
dime76237643d_im_e
dimer85625603d_imer
dimes85833043d_imes
dimly114913483d_imly
dims75435023d_im_s
dingo74720793d_ingo
dino56036753d_i_no
dipso85111553d_ipso
disco85616073d_isco
ditto65315603d_itto
doily95321033doily_
domino92611493domino
doomy116018263doomy_
dormy115817473dormy_
drily95816523drily_
dumbo105614063d_umbo
dummy134712783dummy_
duomo839753duom_o
fairy115318283fairy_
gaily95020973gaily_
gammy135514893gammy_
gamy105427533ga_my_
grimy114312603grimy_
hairdo1036433hairdo
hairy115316833hairy_
hammy155113433hammy_
jammy194810193jammy_
kayo116417553ka__yo
laity85318903laity_
limbo95614813_limbo
limo65529733_lim_o
limy95727713_limy_
maim85831493maim__
maimed114812663maimed
maimer104514593maimer
maims96321793maim_s
malmy124816343malmy_
mambo115215743ma_mbo
mammy115215163mammy_
mayo96524303ma__yo
mimeo96018683_mimeo
palmy126016733palmy_
primo95017913prim_o
rainy85921083rainy_
rammy124312493rammy_
rimy96621283_rimy_
saimin8313663saimin
sambo95118013sa_mbo
skimo116312543skim_o
slimy105417423slimy_
stimy105114743stimy_
tammy124013223tammy_

Search took 6 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.373479064.3
2DLD Change Limit1127161325.08022188.2
3Display Results1321320.0304400.0
 (SQL Overall)1786911325.48332590.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.