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

59 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
trepanning134415(None) 
trapanning1343211trapanning
preplanning1643692preplanning
remanning12229032_remanning
repinning12258972_repinning
replanning1345312_replanning
trephining1644932trephining
branning112911093br__anning
inspanning1343203inspanning
japanning1943383_japanning
panning104019393___panning
prepacking2145773prepacking
preparing14311643prepa_ring
prepasting15168883prepasting
prepaving1787233prepa_ving
prepaying1747973prepa_ying
preplanting1645933preplanting
prewarning16135193prewarning
recaning111416693_reca_ning
recanting122414823_recanting
reconning121410793_reconning
redonning11127643_redonning
reearning1039053_reearning
regaining112411083_regaining
rehanging1437563_rehanging
relanding112110923_relanding
remaining122212793_remaining
remanding132211143_remanding
repacking1838283_repacking
repainting13128973_repainting
repairing12310013_repairing
repaneling1345733_repaneling
reparking1638923_reparking
repassing12249423_repassing
repasting122312843_repasting
repaving142810743_repa_ving
repaying142712393_repa_ying
repenting122316553_repenting
repining114116593_rep_ining
replanting1338523_replanting
repugning1335863_repugning
rerunning1036523_rerunning
retaining102114733_retaining
rewinning13257443_rewinning
spanning113311083__spanning
tanning83618253t___anning
tenanting1036213t_enanting
training93015863tr__aining
trancing112812023tr__ancing
treading103515333tre_a_ding
treadling1137503tre_adling
treating92519613tre_a_ting
trending103012833tre__nding
trepang10257293trepa___ng
trepanned1243913trepann_ed
trepanner1143523trepann_er
trepanners1243083trepanners
trespassing1442313trespassing
truanting1035603tr_uanting

Search took 10 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.423422437.4
2DLD Change Limit140603598.59316362.5
3Display Results59590.0331787.9
 (SQL Overall)178691599.04919747.0
 
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.