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

156 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
implant1131133(None) 
implants1237881implants
displant11412222displant
emplane11410012emplane
explant16310132explant
impact122310442imp_act
impaint11511212impaint
impart102715132imp_art
implanted1475492implanted
implanter1385362implanter
imprint11312552imprint
misplant12410752misplant
pieplant1268732pieplant
plant75437112__plant
reimplant1395302reimplant
replant93318532replant
simulant1048082simulant
airplane1067793airplane
alant55742293__alant
ambulant1247163ambulant
amplest11312333amplest
ashplant1345413ashplant
aslant6317753_aslant
biplane1139033biplane
callant94121223callant
complaint15410243complaint
compliant1549663compliant
coolant9316463coolant
deplane10311413deplane
dimpling14199023dimpling
diplont10311693diplont
displants1248073displants
dopant9316133dop_ant
eggplant1243973eggplant
emanant9411083emanant
emplace1338263emplace
emplaned1337153emplaned
emplanes1239503emplanes
enplane939723enplane
explants1737023explants
gallant83517113gallant
gelant72821673_gelant
gellant83214053gellant
haplont12412563haplont
imblaze2044313imblaze
immane1038873im_mane
impacts13266503imp_acts
impaints1236243impaints
impair1035993imp_air
impala10256923imp_ala
impalas11236953impalas
impale102811653imp_ale
impaled12288503impaled
impaler11298393impaler
impales113311763impales
impaling1338253impaling
impanel1137093imp_anel
impark14287063imp_ark
imparts11298533imp_arts
impaste11258003imp_aste
impasto11275193imp_asto
impawn1333253imp_awn
impawns1433323impawns
impeach1644273impeach
impearl1154453impearl
impeccant1743613impeccant
impellent1346443impellent
impend11478783imp_end
imping114315333imp_ing
implanters1484153implanters
implanting1545313implanting
implead12315823implead
impleads13294593impleads
impled113812503impl_ed
implement1549533implement
implicit1446813implicit
implied1238613implied
implies11312113implies
implode12156103implode
implore11176703implore
imply124911833impl__y
implying1635533implying
impone103011853imp_one
import102713753imp_ort
important1346723important
impost103011773imp_ost
impotent1249533impotent
impound1235393impound
imprest11310203imprest
imprints1247303imprints
impudent1346283impudent
impugn1143153impugn_
impugns1243333impugns
incant82418503i_ncant
infant92315133i_nfant
inhalant1147393inhalant
inland7310313i_nland
instant7815343instant
insulant849873insulant
intrant7318753intrant
island738533i_sland
issuant748263issuant
iterant7317783iterant
libelant1048563libelant
meant76537203_m_eant
midland1136603midland
migrant10314313migrant
misplan1147773misplan_
misplans1238863misplans
misplants1347313misplants
mutant8317693_mutant
oppilant1246023oppilant
pant66061253__p_ant
pieplants1355433pieplants
plaint85323203__plaint
plait75631573__plait
plan65833943__plan_
plane74929143__plane
planet84228353__planet
plank115221143__plank
plans75731273__plans
plants84921803__plants
plat66048873__pla_t
pliant83918823__pliant
preplant12712913preplant
rampant11312173ramp_ant
reimplants1483533reimplants
replan83215823replan_
replans92814943replans
replants102811243replants
reptant92817073reptant
rimland1035663rim_land
rimpling13219663rimpling
sealant73118303sealant
sibilant10158273sibilant
simplest122310223simplest
simplist12249683simplist
simulants1144993simulants
slant55238703__slant
splat76129343_spla_t
splent84720193_splent
splint85223283_splint
stimulant1145163stimulant
supplant1247823supplant
timpana11226123timp_ana
timpani11266143timp_ani
timpano11235863timp_ano
ululant747693ululant
umlaut838033um_laut
unplait948603unplait
unpliant1047143unpliant
upland938863_upland
vigilant1246423vigilant
volant9316323_volant
waxplant20144603waxplant
wimpling16207483wimpling

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 Filter1786911340270.1601116818.8
2DLD Change Limit1340271567.15318737.2
3Display Results1561560.0632476.2
 (SQL Overall)1786911567.37624226.0
 
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.