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

111 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
nictations127831(None) 
dictations1389701dictations
nictation1189271nictation_
citations11312502ci_tations
dictation12810562dictation_
incitations13310882incitations
jactations1936892jactations
lactations1239422lactations
natations91412492n_atations
nictating1237572nictati_ng
nidations1039212ni_dations
nitrations10312032nitrations
notations91512972n_otations
nutations91411762n_utations
siltations1038552siltations
actuations1239293_actuations
agitations11310063agitations
animations12312193ani_mations
annotations1146883annotations
arcuations1249343arcuations
cations94524143__c_ations
ciliations121111003ciliations
citation10314363ci_tation_
cunctations1576153cunctations
dentations11413633dentations
dictating1338883dictati_ng
dictators1247363dictat_ors
dictions111812673dic__tions
dilatations1246413dilatations
dilations102614453di_lations
dotations101411633_dotations
elicitations1446803elicitations
eructations1347233eructations
excitations2049003excitations
fetations12511383_fetations
fictions132410743fic__tions
fictitious1553093fictitious
filiations13119093filiations
filtrations1445623filtrations
fixations1936353fi_xations
flirtations14104263flirtations
flotations1366873flotations
gestations1139773gestations
gustations1147233gustations
guttations1145593guttations
himations1438803hi_mations
ideations1039903_ideations
illations9311393_illations
imitations1259963imitations
incantations1446643incantations
incautions1245973incautions
inceptions1448533inceptions
incitation12312223incitation_
incretions1248653incretions
incubations1547303incubations
indications14310973indic_ations
inflations13310323inflations
initiations11410723initiations
invitations1449053invitations
iodations1039113_iodations
jactation1838143jactation_
lactation11310813lactation_
libations112510443li_bations
librations12149063librations
ligations102111993li_gations
limitations1348183limitations
lineations1039543lineations
liquations1945623liquations
locations112512743loc_ations
mentations12312583mentations
migrations13168683migrations
miscitations1647053miscitations
mutations111211453_mutations
narrations1038943narrations
natation81513933n_atation_
nations74720563n___ations
negations102811963n_egations
nervations1359483nervations
nicotins1058173nic_oti_ns
nictates1039593nictat__es
nidation9410583ni_dation_
nitration9313443nitration_
notation81414603n_otation_
novations12139003n_ovations
nucleations1345313nucleations
nunnations1095903nunnations
nutation81513103n_utation_
nystatins1244753nystati_ns
peltations12311553peltations
pinnations1236883pinnations
plications14310493plic_ations
potations111615073_potations
punctations1585353punctations
quotations19146283quotations
recitations13314203recitations
restations10315843restations
rotations91613843_rotations
saltations10310623saltations
sanitations11410843sani_tations
siltation939213siltation_
sinuations1039413sinuations
situations1038433situations
sonications1349953sonic_ations
stations82415223__stations
titrations1039173titrations
vacations141910553vac_ations
vibrations15157373vibrations
violations1337963violations
visitations1447673visitations
vitiations1338743vitiations
vocations141911423voc_ations

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 Filter1786911406030.1531167915.0
2DLD Change Limit1406031116.80020676.9
3Display Results1111110.0462413.0
 (SQL Overall)1786911116.99925530.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.