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

118 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
bepaints123511(None) 
bepaint11312181bepaint_
depaints1136641depaints
repaints1038481repaints
bepainted1484342bepainted
betaines10313292betaines
bezants1877342beza_nts
depaint10314592depaint_
impaints1236242impaints
paints85921832__paints
repaint9318362repaint_
reprints1039902reprints
appoints1286403appoints
attaints846493attaints
baits76630583b__ai_ts
baptists1236723baptists
beadings123711783beadings
beanies93821093be_anies
beanos85516513be_a_nos
beans75734693be_a_n_s
bearings113912253bearings
beasts84519723be_a_sts
beatings114113233beatings
beats76042243be_a__ts
beauts86015283be_a_uts
bedamns1235733bedamn_s
beddings13407923beddings
bedpans1237173bedpa_n_s
bedsits1037563bedsi_ts
beduins1039123beduin_s
beelines103312803beelines
befits114711503be_fi_ts
begins94415303be_gin_s
beguines11127213beguines
behinds1335283be_hinds
beings94613033be__ings
bellings113811153bellings
beltings11369253beltings
bemists113410703be_mists
bents76033693be___nts
benzines1938213benzines
benzins1838693benzin_s
bepainting15144883bepainting
berlines102315453berlines
berlins93216013berlin_s
betaine9413783betain_e
bethinks1765043bethinks
bewails1277553bewai_ls
bezant17814543beza_nt_
bezzants1843643bezzants
bints76130183b___ints
blains84516373b_lain_s
bluepoints1452123bluepoints
blueprints1442223blueprints
brains85125473b_rain_s
brants85723053b_ra_nts
byzants2153223byza_nts
decants103514443deca_nts
delaines9312963delaines
depainted1375843depainted
departs104310683depa_rts
depicts12358463dep_icts
detains83716093detain_s
deviants1236733deviants
dopants1038433dopa_nts
elains64919853_elain_s
elints65816423_e_lints
epacts105010393_epa_cts
eyepoints1443103eyepoints
faints94818783__faints
feints94813873fe__ints
gelants82611443gela_nts
haints94417583__haints
heparins13310123heparin_s
impaint11511223impaint_
imprints1247303imprints
leptins92412693leptin_s
levants1037723leva_nts
mediants11299493mediants
mispaints13106183mispaints
outpaints1145283outpaints
pains75138283__pain_s
paint75443693__paint_
painty114714753__painty
pants76536923__pa_nts
papains11312363papain_s
pedants10310113peda_nts
penpoints1344553penpoints
pepinos1137693pep_inos
pepsines1239883pepsines
pepsins11310433pepsin_s
pints75936223__p_ints
plaints94012053_plaints
points85618533__points
preprints1347473preprints
prints84320103__prints
rebaits9312573rebai_ts
recants93217093reca_nts
regains84316583regain_s
remains94117913remain_s
remints95117293re_mints
repainted1277863repainted
repairs9319973repai_rs
repasts93611933repa_sts
repents93717623rep_ents
repines94927383rep_ines
repins84924313rep_in_s
replants102811243replants
reprint9318983reprint_
retains74522253retain_s
retints74717013re_tints
saints65122423__saints
secants93413893seca_nts
spaits85017473_spai_ts
splints94511743_splints
sprints94113773_sprints
taints64520533__taints
tenants7311013tena_nts

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.423422437.4
2DLD Change Limit1461621187.23320207.7
3Display Results1181180.0333575.8
 (SQL Overall)1786911187.68923239.8
 
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.