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 “tailgated” 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
tailgated114512(None) 
tailgate946811tailgate_
tailgater1044341tailgater
tailgates1046521tailgates
tailcoated1343282tailcoated
tailgaters1143382tailgaters
tailwater1244512tailwater
ablated102513443_abl_ated
alated75625143_a_l_ated
alighted1347673_alighted
ciliated11510943_ciliated
dilated93115823_dil_ated
epilated11310753epil_ated
falcated1438473fa_lcated
filiated12610083_filiated
galeated104111573ga_leated
ligated92414133_li_gated
navigated1445483navigated
obligated13186903obligated
palliated1238493palliated
palmated132511003pa_lmated
palpated13249763pa_lpated
pileated112711133_pileated
salivated1337473salivated
tableted1137533tabl_eted
tabletted1244833tabletted
tabulated1237303tabulated
tailed74424663tail___ed
tailgating1244873tailgating
tailored936203tail_ored
tailrace1044883tailrace_
tailraces1144903tailraces
tailwaters1343503tailwaters
tainted83512423tai__nted
talented938423ta_lented
tallaged10257923ta_llaged
targeted1037483ta_rgeted
tartrated1096633tartrated
tilted74616863t_il__ted
titillated1144063titillated
titrated92611683t_itrated
togated94410663t__ogated
toileted936993toil_eted
tollgate946253tollgate_
tollgates1046053tollgates
tritiated1047523tritiated
vacillated1654613vacillated
validated1446493validated
valuated12239203va_luated
variegated1543103variegated

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 Filter1786911486410.1531167915.0
2DLD Change Limit148641507.89318832.0
3Display Results50500.0163125.0
 (SQL Overall)178691508.06222164.6
 
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.