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 “lalique” 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
lalique164442(None) 
laliques1744831laliques
cacique20205692cacique
caique17318802ca_ique
calque17289842cal_que
cazique27194032cazique
clique17289192_clique
oblique1844692oblique
relique1636822relique
silique1645642silique
alible8311973_alible
alike95523963_ali_ke
aline57243153_ali_ne
aliquot1646493_aliquot
alive85722513_ali_ve
allium8311243alli_um
antique1638883antique
applique2142583applique
baroque1835103baroque
barque17239553ba_rque
basque17259083ba_sque
bezique2743173bezique
caciques21165373caciques
caiques18248793ca_iques
calibre1136603calibre
caliche14329953caliche
calicle113111433calicle
calipee11412913calipee
calqued19306523cal_qued
calques182710193cal_ques
casque17299273ca_sque
caziques28193773caziques
claque17338563_claque
cliqued19266683_cliqued
cliques18309203_cliques
cliquey21295693_cliquey
cliquy20324713_cliquy
cloque17288743_cloque
fatigue1144393fatigue
fique1739143__fique
galilee8312213galilee
garigue935583garigue
habitue12266703habitue
halibut1289053halibut
halide103417993hali_de
halite93624233hali_te
halitus10339963halitus
kalium1239473kali_um
labiate91313573labiate
labile8315223labi_le
labium10410243labi_um
lacquer18135153la_cquer
lacquey21143803la_cquey
lamiae84817453lami_ae
laminae93512973laminae
langue71012173la_ngue
larine63927043lari_ne
latitude9185513latitude
lawine93316463lawi_ne
lawlike14137073lawli_ke
macaque2044053macaque
malice104818483mali_ce
maline84529083mali_ne
manque17259513ma_nque
marque172410503ma_rque
masque17249383ma_sque
obliqued2043353obliqued
obliques1944513obliques
odalisque1951023odalisque
perique1837523perique
pique16410173__pique
plaque17317643_plaque
plastique2043043plastique
pratique19134283pratique
pulque1736213pul_que
reliques1736903reliques
sacque17107113sa_cque
saline65132703sali_ne
siliqua1643983siliqua
siliquae1743233siliquae
siliques1745353siliques
ubique1784883_ubique
unique1558163_unique
valine94623093vali_ne
valise92917643vali_se
value85719093val__ue

Search took 8 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 Limit134027867.32618294.7
3Display Results86860.0302866.7
 (SQL Overall)178691867.77922970.9
 
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.