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

126 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
appoint1161248(None) 
appoints1286401appoints
adjoint15108282adjoint
anoint6423632a_noint
appointed1444802appointed
appointee1345002appointee
appointer1354422appointer
appointor1342892appointor
apposing1337402apposing
aroint6328152a_roint
point75338732__point
reappoint1346322reappoint
waypoint1645332waypoint
account11109043account
adjoin14107293adjoin_
adjoins1585983adjoins
adjoints16103873adjoints
adroit7518793adroi_t
aloin55227423a_loin_
aloins65022203a_loins
alpine84417373alp_ine
altoist7313393altoist
amboina1137963amboina
amount8414483a_mount
amping114317573amp_ing
anoints7311063a_noints
aperient10715153aperient
aphonia122711883aphonia
aphonic142713393aphonic
aphorist13412513aphorist
aping87327233a_p_ing
apomict1349053apomict
aport75432173a_po_rt
apparat11711713apparat
apparent1248263apparent
append1138273app_end
appetent1248083appetent
applet105917433app_let
applicant1545443applicant
applied1247483applied
applier1137903applier
applies11311223applies
applying1634653applying
appointees1453043appointees
appointers1443773appointers
appointing1545323appointing
appointive1793803appointive
appointors1462853appointors
appose10411993appo_se
apposed1247853apposed
apposer1147483apposer
apposes11511473apposes
apposite12410013apposite
apprise11310193apprise
apprize2038183apprize
approving1745053approving
apron7318833apro_n_
aproning11311793aproning
aprons8316993apro_ns
aroints7313143a_roints
aroynt9312893a_roynt
arpent84822093arp_ent
asquint16208323asquint
attaint7313473attaint
autoing8314043autoing
ballpoint1345993ballpoint
bepaint11312183bepaint
capping143819673capp_ing
cashpoint1644093cashpoint
dapping133714793dapp_ing
dappling1436843dappling
depaint10314593depaint
disappoint1554823disappoint
drypoint1444793drypoint
endpoint1147103endpoint
eyepoint1345793eyepoint
gapping134214783gapp_ing
gunpoint1146673gunpoint
haplont12412563haplo_nt
happing153817233happ_ing
hypoing1636503hypoing
impaint11511223impaint
imprint11312563imprint
joint125227723__joint
lapping124117023lapp_ing
mapping143413993mapp_ing
midpoint13117493midpoint
mispoint121012363mispoint
napping123514183napp_ing
nonpoint10411863nonpoint
opponent1246403opponent
opposing1336383opposing
outpoint10311513outpoint
paint75443693__paint
papain10313793papain_
papains11312373papains
papist102618753pap_ist
penpoint1249453penpoint
pinpoint1248993pinpoint
pint66963183__p_int
plaint85323203_plaint
poind84217913__poind
pointe84619313__pointe
points85618533__points
pointy114913283__pointy
pooing93820683_pooing
print74837463__print
rapping123619103rapp_ing
rappini11347573rapp_ini
rapport11311223rappo_rt
reappoints1443603reappoints
repaint9318363repaint
reprint9318983reprint
sapphist1545773sapphist
sapping123519313sapp_ing
splint85223283_splint
spoilt85016593_spoilt
sprint84526793_sprint
tapping123317133tapp_ing
unjoint1449233unjoint
upgoing1135353upgoing
upping114013703upp_ing
wapping153514603wapp_ing
waypoints1742443waypoints
yapping153412613yapp_ing
zapping213211473zapp_ing

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 Filter1786911340270.810220606.2
2DLD Change Limit1340271268.59615591.8
3Display Results1261260.0462739.1
 (SQL Overall)1786911269.45218905.1
 
Comments and Suggestions welcome: FaceBook ~ UserVoice ~ SQLServerCentral  |  Developed By: Tom Keller Consulting © 2011-2026  |  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.