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

152 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
luxation153823(None) 
laxation1538421laxation
lunation8311921lunation
luxations1637271luxations
duration9312692duration
fixation1837072fixation
laudation1088132laudation
lavation1139972lavation
laxations1637622laxations
legation92412932legation
libation102411362libation
ligation92313092ligation
lobation102110552lobation
location102113912location
lunations9310722lunations
luxating1645612luxating
mutation101412882mutation
nutation81513102nutation
pupation1269502pupation
sudation9310802sudation
taxation1537992taxation
ululation938092ululation
vexation1838782vexation
ablation10312433ablation
adnation9310783adnation
adulation10311013adulation
aeration8319933aeration
agnation9311713agnation
alation72920553_alation
auction93412933au_ction
audition979173audition
aviation11312743aviation
cation83925503__cation
caudation1269993caudation
causation1199523causation
citation10314363citation
clavation1447003clavation
conation101420883conation
creation102816513creation
delation92318083delation
dilation92215463dilation
donation91513783donation
dotation91412733dotation
durations10311463durations
education12310203education
elation73620453_elation
elevation1239233elevation
elution72913823elu__tion
eluviation1376613eluviation
emulation11312393emulation
enation73419233_enation
equation17310483equation
exaction1738953_exaction
exudation1787693exudation
fetation11613143fetation
fixations1936353fixations
flotation1267813flotation
fluxion1735043flux__ion
function1337843function
furcation1448353furcation
gelation93014433gelation
gumption1343983gumption
gustation1047963gustation
guttation1046173guttation
gyration1237763gyration
halation11313853halation
himation1339743himation
ideation9310493ideation
illation8311943illation
iodation9310383iodation
junction1736203junction
kation104315683__kation
lactation11310813lactation
lallation939493lallation
latino64120473l__atino
laudations1146843laudations
laureation1046153laureation
lavations1238973lavations
laxative1845093laxative
lection92614863l_ection
legations102711923legations
lenition8310083lenition
libations112510443libations
libration111510163libration
ligations102111983ligations
lineation9310763lineation
liquation1846553liquation
lobations11219613lobations
lobulation1247233lobulation
locations112512743locations
locution10227663locution
lotion65716523l__otion
lunarian847293lunarian
lunatic938753lunati_c
lunatics1045473lunatics
lustration1048353lustration
luxate1338083luxat__e
luxated1535713luxat_ed
luxates1436973luxat_es
munition1038763munition
mutations111211453mutations
natation81513933natation
nation64322803__nation
negation92913023negation
nidation9410583nidation
notation81414603notation
novation111710013novation
nunnation9126563nunnation
nutations91411763nutations
oblation1039863oblation
oration71617713_oration
ovation101510023_ovation
ovulation1238983ovulation
placation1339773placation
planation11310123planation
plication13311683plication
potation101716783potation
pulsation1137143pulsation
punition1038373punition
pupations1338123pupations
purgation1247393purgation
question1745823question
quotation18146973quotation
ration64226013__ration
relation82619773relation
relaxation1746453relaxation
rogation91612053rogation
rotation81615453rotation
ruction93611613ru_ction
ruination9311273ruination
salutation1048903salutation
sedation9312453sedation
solation8916153solation
station72717243_station
suasion739363su_asion
sublation11311013sublation
subluxation2043823subluxation
suction93713043su_ction
sudations1039903sudations
sulcation11710733sulcation
sulfation1288783sulfation
summation1347803summation
taxations1636863taxations
tuition738823tu_ition
ululations1037143ululations
unction9310663_unction
vacation131911893vacation
valuation1249973valu_ation
venation11513503venation
vexations1937753vexations
vocation132311983vocation
zonation171410723zonation

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 Filter1786911461620.1561145455.1
2DLD Change Limit1461621527.72018932.9
3Display Results1521520.0632412.7
 (SQL Overall)1786911527.93922508.0
 
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.