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

You can choose a higher Change Limit to return more words, although it will take longer.
to automatically increase the Change Limit after seconds.

86 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
earlobes105614(None) 
earlobe946541earlobe_
aerobes9311492aer_obes
earlocks1435692earlocks
enrobes92211112enr_obes
adobes94411533_a_dobes
aerobe8412403aer_obe_
aloes54933673_a_lo_es
arbores94016033_arbores
areoles71016953_areoles
arkoses113910833_arkoses
arles56735743_arl__es
arrobas969213_arrobas
barbes104526233bar__bes
barlows12259973barlo_ws
calloses10313393calloses
cargoes104415223cargo_es
caribes113715643car_ibes
carioles10817073carioles
carles85435083carl__es
carlines103521653carlines
carloads1138393carloads
carobs104818103car_ob_s
darioles9710693darioles
eagles73819163eagl__es
earaches13411313earaches
earlaps936393earl_aps
earldoms1144223earldoms
earless74316073earl_ess
earlier72612743earl_ier
earliest82415243earl_iest
earliness939693earliness
earlock1336923earlo_ck
earls56127513earl___s
earphones1448393earphones
earstones948523earstones
earwaxes1844703earwaxes
earworms1346783earworms
elopes85918163e__lopes
employes1555943employes
encloses10911053encloses
enrobe86610793enr_obe_
enrobed10279253enr_obed
enrober9218623enr_ober
enrobers10236953enr_obers
erodes74819883e_r_odes
eroses65327053e_r_oses
explodes1845803explodes
explores1746253explores
farles96025783farl__es
galores82614343ga_lores
garotes8614563gar_otes
garrotes969363garrotes
gearboxes1942933gearboxes
globes94314543__globes
halloes104021523hallo_es
haloes94623863ha_lo_es
haploses1338853haploses
harlots103413293harlo_ts
karaokes1145013karaokes
lobes75331003___lobes
marlines103818713marlines
marlites103415263marlites
narcoses103910543narcoses
oarlocks1445103oarlocks
parcloses1347963parcloses
parles86334403parl__es
parlors9312913parlo_rs
parlours1036153parlours
parlous9414293parlo_us
parolees104313983parolees
paroles95025883par_oles
pearlites1138233pearlites
probes104119453_pr_obes
reprobes121910293repr_obes
robes75133303__r_obes
saprobes1237033saprobes
sarodes84216143sar_odes
saroses73619333sar_oses
strobes93813263str_obes
unrobes9269733unr_obes
varioles11711123varioles
wardrobes1583793wardrobes
warlocks1735363warlocks
warlords1245303warlords
yearlies1137603yearl_ies

Search took 9 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.423422437.4
2DLD Change Limit146162867.65619091.2
3Display Results86860.0302866.7
 (SQL Overall)178691868.10922036.1
 
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.