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

57 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
warplane134598(None) 
warplanes1445891warplanes
airplane1067792airplane
warpage1336402warp_age
waxplant20144602waxplant
aeroplane1146593aeroplane
airplanes1187233airplanes
alane56135613_a__lane
arcane81216743_ar_cane
biplane1139033_biplane
carline93923613car_line
carpale113414353carp_ale
deplane10311413_deplane
earphone1348253earphone
emplane11410013_emplane
enplane939723_enplane
farmland1454233farmland
garland948703gar_land
grapline1138723grapline
gyroplane1544003gyroplane
hardline12310273hardline
jackplane2443003jackplane
marline93320953mar_line
maryjane2043043maryjane
paravane1348103paravane
parkland1545373parkland
parlance1248723par_lance
parlante1039693par_lante
plane74929143___plane
purslane1045783purslane
sailplane1144093sailplane
seaplane1049163seaplane
skiplane1444833skiplane
swampland1741983swampland
tailplane1144263tailplane
tarpan82814293tarp_an_
tarpans92513533tarp_ans
towplane1345313towplane
trapline10411863trapline
triplane1039113triplane
volplane1344313volplane
warble113516603warbl__e
warbling14198943warbling
warfare1336733war_fare
warlike142410473war_like
warpages1437053warp_ages
warpath1545203warp_ath
warping133715183warp_ing
warpwise1642853warpwise
warrant10614243war_rant
warsle93112923warsl__e
warsling12198593warsling
wartlike1537043wartlike
wasplike1734893wasplike
waxplants21142803waxplants
workplace2042733workplace
yardland1343763yardland

Search took 8 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.486367677.0
2DLD Change Limit146162577.25020160.3
3Display Results57570.0301900.0
 (SQL Overall)178691577.76623009.4
 
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.