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

47 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
towplane134531(None) 
towplanes1444681towplanes
toeplate1047612toeplate
tolane64316582to__lane
topline92313182to_pline
towline102911542tow_line
triplane1039112triplane
volplane1344312volplane
airplane1067793airplane
biplane1139033_biplane
bowline123613113bow_line
compline14313553compline
cowbane1437673cow_bane
deplane10311413_deplane
downland1364533downland
emplane11410013_emplane
enplane939723_enplane
lowland1134693low_land
monoplane1347483monoplane
noplace1137393no_place
plane74929143___plane
seaplane1049163seaplane
showplace1952863showplace
skiplane1444833skiplane
tailplane1144263tailplane
template1238433template
tinplate1047733tinplate
toeplates1147173toeplates
tolan55124013to__lan_
tolanes74216303to__lanes
tolans64319273to__lans
tollage82610163to_llage
toplines102412563to_plines
topple104411323toppl__e
toppling13197353toppling
torulae758553torula_e
towage1039833tow__age
toweling122910373toweling
towlines112610343tow_lines
towpath1544043towp_ath
trapline10411863trapline
triplanes1148803triplanes
triptane1047563triptane
tumpline1237113tumpline
volplaned1542733volplaned
volplanes1444673volplanes
warplane1345983warplane

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 Filter1786911461620.1731032896.0
2DLD Change Limit146162479.33015665.8
3Display Results47470.0133615.4
 (SQL Overall)178691479.51618778.0
 
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.