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 “hyperplanes” with Change Limit: [1] [2] [3] [4] [5]

You can choose a higher Change Limit to return more words, although it will take longer.
to automatically increase the Change Limit after seconds.

71 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
hyperplanes215560(None) 
hyperplane2055381hyperplane_
superplanes1547432superplanes
hydroplanes2055873hydroplanes
hyperlinks2263883hyper_links
hyperplasia2155533hyperplasia
hyperplasias2254833hyperplasias
hyperploids2255183hyperploids
hyperpnea1954843hyperp__nea
hyperpneas2054773hyperp__neas
hyperspaces2354313hyperspaces
superplane1447203superplane_
aeroplanes1246884__aeroplanes
airplanes1187234__airplanes
copperplates1752224copperplates
deplanes11311214__de_planes
emplanes1239504___emplanes
enplanes1039484___enplanes
gyroplanes1644294gy_roplanes
heelplates1583704h_eelplates
heptanes1339004h__e_ptanes
homeplaces1944374home_places
hydrolases1746284hy_drolases
hydrophanes2356424hydrophanes
hydroplane1955844hydroplane_
hydroplaned2154164hydroplaned
hypallages1951814hyp_allages
hyperaware2153314hyperaware_
hyperbolae2054604hyperbola_e_
hyperbolas2054984hyperbola__s
hyperboles2055944hyper_boles
hyperbolizes3154844hyperbolizes
hypercharges2653494hypercharges
hypercubes2254004hyper_cubes
hyperfine2045914hyper_fine_
hypergamies2255444hypergamies
hyperlink2144664hyper_lin_k
hyperlinked2452794hyper_linked
hypermania20117174hyper_mania
hypermanias21116624hyper_manias
hypermanic22116634hyper_manic
hyperons1649204hyper__on_s
hyperopes1947504hyper__opes
hyperopias2047374hyperopia__s
hyperphagia2594174hyperphagia
hyperphagias2683844hyperphagias
hyperphagic2784044hyperphagic
hyperplastic2464974hyperplastic
hyperploid2156054hyperpl_oid
hyperploidies2463774hyperploidies
hyperploidy2554004hyperploidy
hyperpneic2255174hyperp__neic
hyperpolarizes33122914hyperpolarizes
hyperpure1954104hyperp_ure_
hypersaline1956374hypersaline_
hyperspace2253704hyperspace_
hypersthenes2353794hypersthenes
hypertense1855804hyper_tense
interplants13116754interplants
overplans14249574_overplan_s
overplants15227334_overplants
peneplanes1444324__peneplanes
perilunes1147164__perilunes
perplexes2044684__perplexes
preplaces1578754__preplaces
preplans1249614__preplan_s
purslanes1145524__purslanes
seaplanes1148714__seaplanes
superplayer18103964superplayer
superplayers19103204superplayers
warplanes1445894__warplanes

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 Filter1786911488190.440406115.9
2DLD Change Limit148819718.20318142.0
3Display Results71710.0461543.5
 (SQL Overall)178691718.68920565.2
 
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.