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

84 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
limitation124915(None) 
imitation11510851_imitation
limitations1348181limitations
delimitation1597262delimitation
elicitation1347532elicitation
elimination1348532elimination
imitations1259962_imitations
lamination12311222lamination
levitation1349442levitation
limitational1453542limitational
limitative1544692limitative
litigation1148172litigation
visitation1348592visitation
admiration1347733admiration
agitation10311223_agitation
alimentation14105333alimentation
capitation14311363capitation
cavitation1549133cavitation
ciliation111112493cili_ation
citation10314363__citation
cogitation13410083cogitation
crimination1549413crimination
delimitations1676633delimitations
dictation12810563di_ctation
dilatation1147393dilatation
diminution1344813diminution
divination14139233divination
domination13712373domination
dubitation1377333dubitation
elicitations1446803elicitations
eliminations1447613eliminations
equitation1948343equitation
excitation19410173excitation
felicitation1745103felicitation
filiation121110243fili_ation
flirtation1354823fli_rtation
fumigation1645623fumigation
gemination131410663gemination
habitation1547913habitation
hesitation1349633hesitation
himation1339753him__ation
imitating1238763_imitating
imitative1446333_imitative
imitator1047113_imitat_or
imputation1447123_imputation
incitation12312223incitation
initiation10412103_initiation
invitation13410023invitation
irritation1048973irritation
lactation11310813l_actation
laicization2247903laicization
lamentation13106573lamentation
laminations1339803laminations
levigation1447023levigation
levitations1448293levitations
libation102411363l__ibation
liberation1269993liberation
libration111510163li_bration
ligation92313093l__igation
lineation9310763li_neation
lionization2047883lionization
liquation1846553li_quation
liquidation2143183liquidation
literation10511413literation
litigations1247333litigations
lixiviation2182953lixiviation
meditation13410743meditation
miscitation1547773miscitation
mitigation1348643mitigation
mutation101412883__mutation
nictation1189273ni_ctation
nomination12712103nomination
pixilation1945913pixilation
recitation12315943recitation
rumination12410833rumination
sanitation10412043sanitation
sibilation12128773sibilation
siltation939213si_ltation
simulation1269583simulation
solicitation1445363solicitation
temptation1446383temptation
titivation1347033titivation
visitations1447673visitations
vitiation1239563viti_ation

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 Filter1786911406030.436409841.7
2DLD Change Limit140603846.40621948.6
3Display Results84840.0461826.1
 (SQL Overall)178691846.88825942.4
 
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.