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

87 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
seaplane104916(None) 
seaplanes1148711seaplanes
deplane10311412de_plane
emplane11410012_emplane
enplane939722_enplane
sealant73118302sea_lant
sepaline10311342sepaline
skiplane1444832skiplane
aeroplane1146593aeroplane
airplane1067793airplane
alane56135613__a_lane
aquaplane2052493aquaplane
bedplate1346223bedplate
biplane1139033_biplane
deadline10139053deadline
dealate83617843dea_late
deplaned1238653de_planed
deplanes11311213de_planes
emplace1338263_emplace
emplaned1337153_emplaned
emplanes1239503_emplanes
enplaned1137473_enplaned
enplanes1039483_enplanes
explant16310133_explant
grapline1138723grapline
headland1345613headland
headline12129613headline
heptane1238363he_ptane
leadplant1244073leadplant
peneplane1344663peneplane
plane74929143___plane
replace113214283re_place
replan83215823re_plan_
replans92814943re_plans
replant93318533re_plant
replate93420053re_plate
sailplane1144093sailplane
saline65132703s_a_line
salpae84614273s_alpa_e
sapling103217863s_apling
scabland1344293scabland
scalade10359263sca_lade
scalage103110533sca_lage
scalare93311833sca_lare
scalene9310773sca_lene
scapulae1255433scapula_e
seaborne1055433seaborne
sealable101512693sea_lable
sealants82610743sea_lants
sealing83528563sea_ling
seallike12108323seallike
seaman84015903sea_man_
seamlike14127183seamlike
seapiece1244373seapiece
seaquake21102713seaquake
seascape1245173seascape
seatmate1048573seatmate
seawan94111223sea_wan_
seawans10379943sea_wans
seawant103613413sea_want
seaware1049623sea_ware
seepage1037543seep_age
semblance1544403semblance
semple103212753sempl__e
semplice1447013semplice
separate10310783separate
septage1078403se_ptage
septate9511873se_ptate
setline7313923se_tline
silane62718053s__ilane
skiplanes1544633skiplanes
smallage1145183smallage
soaplike1436903soaplike
splake1259783s__plake
spline86020533s__pline
staple84415823stapl__e
stapling112813153stapling
stealage946583stea_lage
superplane1447203superplane
supplant1247823supplant
swampland1741983swampland
template1238433template
towplane1345313towplane
trapline10411863trapline
triplane1039113triplane
volplane1344313volplane
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.420425454.8
2DLD Change Limit146162878.54617103.0
3Display Results87870.0501740.0
 (SQL Overall)178691879.01619819.3
 
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.