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

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
ratlines8381529(None) 
ratines75328581rat_ines
ratline74517801ratline_
ratlins73615581ratlin_s
alines65735222_a_lines
carlines103521642carlines
catlings113712042catlings
catlins93818842catlin_s
cutlines102413272cutlines
datelines1088842datelines
draglines1145992draglines
fatlings12359302fatlings
flatlines12268432flatlines
gantlines1039332gantlines
graplines1237352graplines
hotlines11811642hotlines
jawlines18126362jawlines
kaolines1239292kaolines
latrines8515002latrines
malines93625602ma_lines
marlines103818712marlines
outlines82418092outlines
patines95225762pat_ines
potlines10714212potlines
pralines102217722pra_lines
railings93412152railings
rallies73823342ralli_es
ralline73518412ralline_
rapines95120862ra_pines
ratanies8312922ratanies
ratfinks1542852ratfinks
ratine65131822rat_ine_
ratings84217402rat_ings
ratites74920682rat_ites
ratlike113912352ratlike_
ratlin64116522ratlin__
rattlings10235512rattlings
ravines104220232ra_vines
reclines103718542reclines
redlines93916082redlines
relines75331322r_elines
retines75134672ret_ines
salines74029412sa_lines
saltines82917792saltines
setlines8312742setlines
taglines92210832taglines
tramlines1139832tramlines
traplines11310362traplines
trotlines939102trotlines
valines104520212va_lines

Search took 9 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 Filter1786911210590.1561145455.1
2DLD Change Limit121059508.61014060.3
3Display Results50500.0331515.2
 (SQL Overall)178691508.79920308.1
 
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.