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

115 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
implants123788(None) 
implant11311331implant_
displants1248072displants
emplanes1239502emplanes
explants1737022explants
impacts13266502imp_acts
impaints1236242impaints
imparts11298532imp_arts
implanted1475492implanted
implanter1385362implanter
implanters1484152implanters
imprints1247302imprints
misplants1347312misplants
pieplants1355432pieplants
plants84921802__plants
reimplants1483532reimplants
replants102811242replants
simulants1144992simulants
airplanes1187233airplanes
alants67722023__alants
ashplants1443533ashplants
biplanes1238573biplanes
callants104112143callants
complaints1646003complaints
coolants1039943coolants
deplanes11311213deplanes
diplonts1146473diplonts
displant11412223displant_
dopants1038433dop_ants
eggplants1342753eggplants
emplaces1438413emplaces
emplane11410013emplan_e
emplaned1337163emplaned
enplanes1039483enplanes
explant16310133explant_
gallants93310373gallants
gelants82611443_gelants
gellants9308283gellants
haplonts1345773haplonts
imblazes2144723imblazes
impact122310453imp_act_
impaint11511223impaint_
impairs1135823imp_airs
impalas11236953imp_alas
impalers12226973impalers
impales113311763imp_ales
impanel1137093imp_anel
impanels1245233imp_anels
imparks15276663imp_arks
impart102715143imp_art_
impaste11258003imp_aste
impastes12238193imp_astes
impasto11275193imp_asto
impastos12244833imp_astos
impawns1433323imp_awns
impearls1253883impearls
impellents1444363impellents
impends12376803imp_ends
impings12348553imp_ings
implanting1545323implanting
impleads13294593impleads
implements1647853implements
implies11312123impl_ies
implodes13106393implodes
implores12127043implores
impones112712253imp_ones
imports11309623imp_orts
imposts11269003imp_osts
impotents1347003impotents
impounds1344123impounds
imprests1246313imprests
imprint11312563imprint_
impugns1243333impugn_s
incants92012803i_ncants
infants102210773i_nfants
inhalants1244473inhalants
inlands838783i_nlands
instants8910153instants
insulants946913insulants
intrants8312863intrants
islands837323i_slands
libelants1145303libelants
midlands1245543midlands
migrants1138183migrants
misplans1238863misplan_s
misplant12410763misplant_
mutants938583_mutants
pants76536923__p_ants
pieplant1268733pieplant_
plaints94012053__plaints
plaits83816473__plaits
planes85028083__planes
planets93914083__planets
planks124116753__planks
plans75731273__plan_s
plant75437113__plant_
plats75531373__pla_ts
reimplant1395303reimplant_
replans92814943replan_s
replant93318533replant_
rimlands1145243rim_lands
sealants82610743sealants
sibilants11134803sibilants
simplists13266503simplists
simulant1048083simulant_
slants64819083__slants
splats84817303_spla_ts
splents93912133_splents
splints94511743_splints
stimulants1253373stimulants
supplants1344873supplants
umlauts943193um_lauts
unplaits1044813unplaits
uplands1036943_uplands
waxplants21142803waxplants

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.440406115.9
2DLD Change Limit1461621157.39019778.3
3Display Results1151150.0462500.0
 (SQL Overall)1786911157.87622688.0
 
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.