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

184 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
lacquer1813515(None) 
lacquers19125031lacquers
lacquey21143801lacquey
claquer18287352cla_quer
lacer75833752lac__er
lacier84020092lac_ier
lacker125325622lac_ker
lacquered2143372lacquered
lacquerer2043252lacquerer
lacqueys22132692lacqueys
masquer18266462masquer
racquet1838742racquet
relacquer2042192relacquer
sacque17107112sacque_
sacques18106862sacques
accuser11347933_accuser
achier113914263_achier
acquest1837173_acquest
acquire1835603_acquire
acquirer1944093_acquirer
acquit17610323_acquit
acuter84412863_acuter
arguer74510543_arguer
backer144525533bac_ker
banquet1839783banquet
barque17239553barque_
barques18259643barques
basque17259083basque_
basques18248673basques
blacker154513513blac_ker
cacique20205693cacique_
caciques21165373caciques
cackler153812573cackler
caique17318803caique_
caiques18248793caiques
calque17289843calque_
calqued19306523calqued
calques182710193calques
casque17299273casque_
casqued19235633casqued
casques18278983casques
chequer2135153chequer
clacker153813773clac_ker
claque17338563cla_que_
claquers19226203cla_quers
claques18279013cla_ques
claqueur19262703cla_queur
conquer1838623conquer
dacker134920753dac_ker
facer105525053fac__er
facture12108943facture
faquir1834313fa_quir
glacier103911303glac_ier
hachure1545723hachure
hacker154822693hac_ker
hackler163512353hackler
jacker194417583jac_ker
jacquard2742553jacquard
jacquerie2752803jacquerie
laager74312783la_ager
labeler92310183labeler
laborer9249513laborer
labour84210933labou_r
labourer1045763labourer
lace66848473lac__e_
laced87132643lac__ed
lacers85225253lac__ers
laces76141763lac__es
lacey105820913lac__ey
laches116528353lac_hes
lacked135324653lac_ked
lackers134120543lac_kers
lackey154813353lac_key
lacquerers2142703lacquerers
lacquering2243603lacquering
lacqueyed2441623lacqueyed
lacuna8118123lac_una
lacunar9136293lacunar
lacune8169673lac_une
lacunes9159623lacunes
ladder84617623la_dder
lader65633723la__der
ladler74314933la_dler
lager65132863la__ger
lagger85919833la_gger
laker95432873la__ker
lakier104716273la_kier
lalique1644423lalique_
laliques1744833laliques
lamber104418493la_mber
lambier113611643lambier
lamer75233703la__mer
lamster9109913lamster
lancer84319973la_ncer
lander74028493la_nder
landler84113203landler
langue71012183langue_
langues81211913langues
languet8713693languet
languor895423languor
langur7109313langu_r
lanker104123003la_nker
lankier113711633lankier
lanner64920603la_nner
lapper104319953la_pper
lapser84113143la_pser
larcener1036493larcener
larder73720973la_rder
lardier83518343lardier
larger74417513la_rger
larker104519243la_rker
larkier113711523larkier
larruper1042753larruper
laser54633323la__ser
lasher94824533la_sher
lassoer7379383lassoer
laster64830633la_ster
later54843923la__ter
lather95124363la_ther
lathier10310833lathier
latter65027893la_tter
lauder73815013la_uder
laugher1136603laugher
launder8309153launder
laveer94110423la_veer
laver85031793la__ver
lawyer12386973la_wyer
laxer125420333la__xer
layer84626473la__yer
layover1334433layover
lazier154214613la_zier
leacher124014843leac_her
leachier1337253leachier
leaguer835793leaguer
lecher113415853lec_her
lecture9149523lecture
lecturer10136033lecturer
licker125222043lic_ker
liqueur1642923l_iqueur
liquor1534203l_iquor
locater93113603locater
locker124019423loc_ker
lucifer1234603lucifer
luckier133811533luckier
macaber1336163macaber
macaque2044053macaque_
macaques2143953macaques
macer912126943mac__er
manque17259513manque_
marque172410503marque_
marquee18218583marquee
marques182610863marques
masque17249383masque_
masquers19195703masquers
masques18239363masques
opaquer1842403opaquer
pacer96131613pac__er
pacier105018683pac_ier
packer144223403pac_ker
parquet18311583parquet
picquet2047743picquet
placater1238013placater
placer105117743plac__er
plaguer10328273pla_guer
plaque17317643pla_que_
plaques18317893pla_ques
racer75233023rac__er
racier85120973rac_ier
racker124824553rac_ker
racquets1944763racquets
relacquers2142023relacquers
sacker125124843sac_ker
slacker133915293slac_ker
tacker124224503tac_ker
tackier133712523tackier
tackler134013323tackler
torquer16205323torquer
uniquer1675783uniquer
vaguer10448443va_guer
valuer93911443va_luer
vaquero1942643va_quero
wacker154920123wac_ker
wackier16369733wackier
yachter1534913yachter

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 Filter1786911340270.423422437.4
2DLD Change Limit1340271846.06322105.7
3Display Results1841840.0632920.6
 (SQL Overall)1786911846.54927285.2
 
Comments and Suggestions welcome: FaceBook ~ UserVoice ~ SQLServerCentral  |  Developed By: Tom Keller Consulting © 2011-2026  |  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.