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 “relations” with Change Limit: [1] [2] [3]

You can choose a higher Change Limit to return more words, although it will take longer.
to automatically increase the Change Limit after seconds.

58 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
relations9241833(None) 
delations102616591delations
elations83719121_elations
gelations102513091gelations
reflations13311231reflations
relation82619771relation_
ablations11311512ablations
aerations9317902aerations
alations82518892_alations
chelations1539082chelations
creations112614542cre_ations
cremations14410712cremations
crenations12511692crenations
dealations11311372dealations
deflations1439712deflations
delation92318082delation_
deletions102610932deletions
dilations102614452dilations
elation73620452_elation_
elutions82513052_elutions
enations83316902_enations
fellations1338062fellations
fetations12511382fetations
gelatins93414092gelati_ns
gelation93014432gelation_
halations12312392halations
illations9311392illations
legations102711922legations
negations102811962negations
oblations1139372oblations
peltations12311552peltations
predations13812152predations
rations74123432r__ations
reactions11711712reactions
recautions1247812recautions
redactions1359132redactions
reflation12412332reflation_
regulations12310712regulations
relating92725442relati_ng
relational1047712relational
relatives1239962relatives
relators83316132relat_ors
relaxations1845642relaxations
relaxins15248682relaxi_ns
relegations1248972relegations
relictions12310022relictions
religions1086602religions
relocations13311142relocations
remotions1149702remotions
repletions1247472repletions
restations10315842restations
revelations14410302revelations
rogations101510822rogations
rotations91613842rotations
sedations10311252sedations
solations9814622solations
venations12311722venations
vexations1937752vexations

Search took 5 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 Filter1786911214360.390458182.1
2DLD Change Limit121436583.87631330.2
3Display Results58580.0301933.3
 (SQL Overall)178691584.29641594.7
 
Comments and Suggestions welcome: FaceBook ~ UserVoice ~ SQLServerCentral  |  Developed By: Tom Keller Consulting © 2011-2026  |  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.