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

92 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
displant1141222(None) 
displants1248071displants
misplant12410761misplant
diplont10311692di_plont
discant103017262dis_cant
dispart101115282disp_art
displace1348652displace
displanted14126632displanted
display1336662displa_y
displays1446292displays
disputant1245742disputant
distant83519952dis_tant
implant11311332_implant
misplan1147772misplan_
misplans1238862misplans
misplants1347312misplants
pieplant1268732pieplant
airplane1067793airplane
ashplant1345413ashplant
aslant6317753_as_lant
biplane1139033bi_plane
deplane10311413d_eplane
descant104315593des_cant
dilatant948203dilatant
dimpling14199023dimpling
diplonts1146473di_plonts
disband1138243dis_band
discants112912023dis_cants
disclaim1345643disclaim
discount11811313discount
dishpan13105523dishpan_
dishpans14115833dishpans
disjoint1649233disjoint
dismast10311233dis_mast
dismount1188223dismount
disparts11109953disp_arts
dispend11289413disp_end
dispersant1346353dispersant
dispirit1149203dispirit
displaced1546793displaced
displacer1446433displacer
displaces1448593displaces
displacing1646413displacing
displanting1546043displanting
displayed1645883displayed
displayer1545833displayer
displaying1746313displaying
displease1245523displease
displode1247643displode
displume1344803displume
disport101015953disp_ort
disputants1344063disputants
disseat83816923dissea_t
dissent84018683dis_sent
dissonant1047473dissonant
distent84120853dis_tent
distract11313023distract
distraint101112903distraint
distrait9414343distrait
divalent1247783divalent
dopant9316133d_op_ant
eggplant1243973eggplant
explant16310133_explant
implants1237883_implants
insulant849883insulant
island738533_is_land
issuant748263_issuant
libelant1048563libelant
mispaint121111893mispaint
mispart111113783misp_art
misplace1437553misplace
misplanted1565443misplanted
misplay1436383mispla_y
misplays1555543misplays
mispoint121012363mispoint
misprint12912973misprint
pieplants1355433pieplants
pissant91012503pis_sant
plant75437113___plant
preplant12712913preplant
reimplant1395303reimplant
replant93318533_replant
sibilant10158273sibilant
simulant1048083simulant
slant55238703__s_lant
splat76129343__spla_t
splent84720193__splent
splint85223283__splint
supplant1247823supplant
vigilant1246423vigilant
visitant1147363visitant
waxplant20144603waxplant

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.420425454.8
2DLD Change Limit146162926.75021653.6
3Display Results92920.0332787.9
 (SQL Overall)178691927.20324807.9
 
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.