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

(Found more than 100 similar words, so Change Limit cannot be increased.)
to automatically search another random word after seconds.

145 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
biplanes123857(None) 
biplane1139031biplane_
airplanes1187232airplanes
deplanes11311212deplanes
emplanes1239502emplanes
enplanes1039482enplanes
hiplines13310592hiplines
planes85028082__planes
silanes72517162si_lanes
skiplanes1544632skiplanes
triplanes1148802triplanes
airlines8312793airlines
airplane1067793airplane_
badlands1236673badlands
balances1279973b_alances
balases93815433b_alases
ballades114211643ballades
banes74945583b___anes
bedplates1445493bedplates
beelines103312803beelines
berlines102315453berlines
bialies93618413bial_ies
biases84618433bi__ases
bibles104617643bibl__es
bicornes12307253bicornes
bifaces1448063bi_faces
bilander1136673bi_lander
bilanders1235963bi_landers
bilayer12347803bi_layer
bilayers13296923bi_layers
bilbies114712343bi_lbies
bilboes114410243bi_lboes
biles75542143bi_l__es
bilges94915633bi_l_ges
billies93923503bi_llies
billings113412633billings
billons93013363billon_s
bines76946793bi___nes
biogases1136143biogases
biolyses1345573biolyses
bioplasms1544383bioplasms
bipacks1745043bip_acks
birianis1056343birianis
birles84920643birl__es
birlings11359613birlings
biryanis1344043biryanis
biteplates1444153biteplates
bivalves1643383bivalves
bizones1837823bi_zones
blades95221253b__lades
blames105121863b__lames
blanks124112893b__lanks
blares85021633b__lares
blazes174817353b__lazes
bolases93315003b_olases
boranes93720403b_oranes
bowlines133211623bowlines
bugbanes1345153bugbanes
bullaces12299433bullaces
butanes9312743b_utanes
bylines1239243b_ylines
byplays1743103bypla_ys
deplane10311413deplane_
deplaned1238653deplaned
dilates83220663di_lates
dioxanes1645373dioxanes
diploes101111493dipl_oes
diplonts1146473diplonts
diploses111110323diploses
dipsades1246493dipsades
displaces1448593displaces
displants1248073displants
emplaces1438413emplaces
emplane11410013emplane_
emplaned1337153emplaned
enplane939723enplane_
enplaned1137473enplaned
epilates10313503epilates
explants1737023explants
flanes94522423__flanes
heptanes1339003heptanes
hipbones1546023hipbones
hipline12311423hipline_
implants1237883implants
inanes62519803_i_nanes
inlaces92512903_inlaces
inlands838783_inlands
islands837323_islands
lanes54946793___lanes
lianes63819323li__anes
lindanes939173lindanes
lipases9209483lip_ases
midlands1245543midlands
midlines112613333midlines
milages103114403mi_lages
millages113212893millages
millines102718063millines
misplaces1537953misplaces
misplans1238863misplan_s
misplants1347313misplants
panes76148693__p_anes
pieplants1355433pieplants
pillages113012603pillages
pipages1289423pip_ages
pipeages1336423pipeages
pipelines13178353pipelines
places104323703__places
plages94520153__plages
plane74929143__plane_
planed94420913__planed
planer84122653__planer
planers94517943__planers
planet84228353__planet
planets93914083__planets
planks124116753__planks
plans75731273__plan_s
plants84921803__plants
plates85432243__plates
replaces123114123replaces
replans92814943replan_s
replants102811243replants
replates102919273replates
rimlands1145243rimlands
sailplanes1244313sailplanes
seaplanes1148713seaplanes
silages82514443si_lages
silane62718053si_lane_
skiplane1444833skiplane_
splakes1349673_splakes
splines94718893_splines
tailplanes1244313tailplanes
tillages93011253tillages
tinplates1147773tinplates
tisanes7311853ti_sanes
tolanes74216313_tolanes
toplines102412563toplines
towplanes1444683towplanes
triplane1039113triplane_
triptanes1147463triptanes
uplands1036943_uplands
villages123010593villages
violates11311193violates
violones1137383violones
volplanes1444673volplanes
warplanes1445893warplanes

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.296603685.8
2DLD Change Limit1461621458.83016552.9
3Display Results1451450.0632301.6
 (SQL Overall)1786911459.18919446.2
 
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.