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

50 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
obturation129714(None) 
obturations13116421obturations
abjuration1945882abjuration
maturation1249512maturation
objurgation2152402objurgation
obscuration1544402obscuration
obturating1346572obturating
obturator1144702obturat_or
saturation1049802saturation
aberration1267203aberration
abjurations2045143abjurations
actuation11310333actu_ation
adjuration1845523adjuration
alteration10612903alteration
botheration1654653botheration
conjuration2049513conjuration
duration9312693__duration
figuration1445913figuration
induration11410613induration
intubation1247773intubation
iteration9515033_iteration
literation10511413literation
lobulation1247233lob_ulation
maturations1348443maturations
nitration9313443nit_ration
obfuscation1852123obfuscation
objurgations2252233objurgations
oblation1039863ob__lation
obligation1346783obligation
obliteration1453893obliteration
obscurations1644023obscurations
observation1665063observation
obstruction15135543obstruction
obtrusion1153723obt_rusion
obturate1077773obturat__e
obturated1245953obturat_ed
obturates1157003obturat_es
obturators1244303obturators
obviation1446093ob_viation
occupation1645183occupation
operation11314003o_peration
oration71617713o___ration
osculation1249673osculation
outstation1046163outstation
ovulation1238983o_vulation
postulation13119133postulation
saturations1148573saturations
situation949423situ_ation
titration9310543tit_ration
trituration1146653trituration

Search took 6 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.406440125.6
2DLD Change Limit140603505.42025941.5
3Display Results50500.0331515.2
 (SQL Overall)178691505.85930498.5
 
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.