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

134 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
iambuses123578(None) 
abuses85119102_a_buses
airbuses1067072airbuses
ambushes1535802_ambushes
amuses85117942_am_uses
campuses1437772campuses
iambus10468892iambu__s
imbues1037962i_mbu_es
limbuses1234902limbuses
nimbuses1244662nimbuses
sambukes1644192sambukes
wammuses1543492wammuses
wampuses1534112wampuses
wamuses1237022wam_uses
abases85720773_a_bases
abuse77119563_a_buse_
abused95614273_a_bused
abuser85413683_a_buser
abusers94710553_a_busers
accuses114112193_accuses
airbusses1153613airbusses
amasses93912853_amasses
ambages1269623_ambages
ambles105121853_amb_les
ambones11312683_ambones
ambries111614533_ambries
ambush1336103_ambus_h
ambushed1644463_ambushed
ambusher1544113_ambusher
ambushers1643433_ambushers
ampules1189433_ampules
amuse75920833_am_use_
amused94412513_am_used
amuser84712623_am_user
amusers94610193_am_users
ankuses1148203_ankuses
anuses66218773_a_nuses
arbutes939703_arbutes
arcuses94814693_arcuses
arguses84711743_arguses
arouses74921293_arouses
barbules1238043barbules
bemuses1139293bem_uses
buses75936013___buses
cactuses1237933cactuses
calluses1039323calluses
camases114216343cam_ases
camasses12388973camasses
cambisms1645793cambisms
cambists1437023cambists
camises114218463cam_ises
campused1535253campused
carouses10614503carouses
caucuses1236783caucuses
causes88026473ca__uses
cayuses12188403ca_yuses
combusts1445493combusts
diabases1137223dia_bases
diapauses1244363diapauses
disabuses1246203disabuses
favuses1336183fa_vuses
galluses936963galluses
gambades1435863gambades
gambes116318313gamb__es
gambles124016203gamb_les
gamboges1435653gamboges
gambusia1343573gambusia
gambusias1443343gambusias
grampuses1442973grampuses
hagbushes1842563hagbushes
hambones1539673hambones
hamburgs1643463hamburgs
hiatuses1135773hia_tuses
hummuses1544453hummuses
humuses1237593hum_uses
iambics13425623iamb_ics
iambs95815053iamb___s
ibises83610533i__bises
ictuses938293i_ctuses
ileuses738673i_leuses
imbibes1334673i_mbibes
imbrues1135493i_mbrues
imbrutes1244203i_mbrutes
imbue939463i_mbu_e_
imbued1136153i_mbu_ed
immerses1235953immerses
immunes1136083i_mmunes
immures1136713i_mmures
imposes113213683i_mposes
impulses1235223i_mpulses
imputes1138083i_mputes
incubuses1343533incubuses
incuses93514853i_ncuses
infuses102711873i_nfuses
jacobuses2042713jacobuses
jambes175914053jamb__es
lambastes13114693lambastes
lambasts12145623lambasts
lambies113015103lamb_ies
lampases1267293lampases
litmuses1044463litm_uses
mamboes135011823mamb_oes
maybushes1942443maybushes
minibuses1344793minibuses
momuses1159263mom_uses
mouses85531423__mouses
muses75134303__m_uses
nimbused1343003nimbused
passuses1036773passuses
pauses84621473pa__uses
radiuses937043radiuses
railbuses1143623railbuses
rambles113118313ramb_les
rebuses94915293_rebuses
rhamnuses14102313rhamnuses
rhombuses1643293rhombuses
rumpuses1235163rumpuses
sambucas1444163sambucas
sambuke1544203sambuke_
samburs11369343sambu_rs
shamuses1336153sham_uses
siameses1036403siam_eses
tabbises12236523tabbises
taluses7311213ta_luses
tamburas12316043tamburas
tamburs11288603tambu_rs
tamises92715973tam_ises
tarbushes1444883tarbushes
valguses1234233valguses
vamooses1345523vamooses
vamoses1239143vam_oses
varuses10310623va_ruses
walruses11554973walruses
wambles143714023wamb_les

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 Filter1786911461620.1731032896.0
2DLD Change Limit1461621346.53022383.2
3Display Results1341340.0632127.0
 (SQL Overall)1786911346.76626410.1
 
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.