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

156 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
lanced9371772(None) 
danced105315251danced
glanced11439231glanced
laced87132641la_ced
lance75126721lance_
lancer84319971lancer
lances84824101lances
lancet84223571lancet
landed84619241landed
aced79540882_a_ced
acned87520662_acned
anted66328242_anted
arced88224162_arced
balanced1356512balanced
banded105223172banded
baned85436352ban_ed
banged104923722banged
banked135021442banked
banned94721342banned
blanched16308602blanched
blanked144011222blanked
cancel105316682cancel
cancer104220922cancer
caned85838092can_ed
canned95022062canned
canoed94618952canoed
canted94825782canted
chanced154113212chanced
clanged114212652clanged
clanked143812252clanked
dance85223132dance_
dancer94817612dancer
dances95120652dances
danged94819482danged
faced117727652fa_ced
fancied133310602fancied
fanged114318222fanged
fanned104117472fanned
farced125216532farced
fenced124412712fenced
flanged123810842flanged
flanked153710642flanked
ganged94619192ganged
glance94312312glance_
glancer103710072glancer
glances104113142glances
hance105424152hance_
hances115621282hances
handed114919982handed
hanged114222392hanged
hanked144220602hanked
hanted104124312hanted
jaunced17335472jaunced
lace66848472la_ce_
lacer75833752la_cer
laces76141762la_ces
lacey105820912la_cey
lacked135324652lacked
laded74232612la_ded
ladled85013482ladled
lagged95520132lagged
laired75216812laired
laked105731122la_ked
lalled74218752lalled
lambed115614782lambed
lamed85235292la_med
lammed113915622lammed
lamped114017542lamped
lanated8313202lanated
lancers93616642lancers
lanceted1137072lanceted
lancets93411162lancets
land56337312lan__d
lander74028482lander
lane45153332lan_e_
lanes54946792lan_es
lanker104123002lanker
lanner64920602lanner
lapped114320032lapped
lapsed94712582lapsed
larded84319092larded
larked114519472larked
lased65132342la_sed
lashed105625212lashed
lasted74323602lasted
latched133914062latched
lated65240672la_ted
lathed104718452lathed
lauded83812152lauded
launce8469182launce_
launces9329002launces
launched1475402launched
laved95028592la_ved
lawed96028322la_wed
layed95127382la_yed
lazed154925842la_zed
lazied164610652lazied
leaned73422542lean_ed
lensed74015472lensed
lined64934642lin_ed
linked114518212linked
linted74021822linted
loaned73816292loan_ed
longed87121372longed
lunched133911822lunched
lunged85418272lunged
lunted74517522lunted
lynched16376752lynched
maced108528692ma_ced
maned86634102man_ed
manned94418642manned
minced114114912minced
nance74721842nance_
nances83618642nances
nuanced1036202nuanced
paced106931682pa_ced
paned85437182pan_ed
panged104722332panged
panned94123432panned
panted95024822panted
placed114318002pla_ced
planed94420912plan_ed
planked143512282planked
planned103810152planned
planted103516122planted
ponced114314812ponced
pranced123714042pranced
raced87635312ra_ced
rance75028512rance_
rances84625442rances
ranched133113602ranched
rancid9513862rancid
ranged84824312ranged
ranked114620742ranked
ranted74324702ranted
sanded84920612sanded
saned65636272san_ed
sauced93913302sauced
slanged94112852slanged
slanted83514742slanted
synced12266962synced
talced93811002talced
tanged84622492tanged
tanked113919292tanked
tanned75219952tanned
tranced104414172tranced
valanced1475462valanced
vaned94622422van_ed
vanned104614482vanned
waned95831782wan_ed
wanked144517152wanked
wanned104318012wanned
wanted104319722wanted
winced124415342winced
yanked144312242yanked
zinced18419412zinced

Search took 3 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 Filter178691825510.1231452772.4
2DLD Change Limit825511562.80029482.5
3Display Results1561560.0602600.0
 (SQL Overall)1786911562.98359903.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.