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

134 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
unpointed123715(None) 
unjointed1755581unjointed
unpainted1237181unpainted
unprinted1238131unprinted
anointed938342an_ointed
appointed1444802appointed
outpointed1344312outpointed
pinpointed1542542pinpointed
pointed103813982__pointed
uncoined111813022uncoin_ed
uncounted1238522uncounted
unjoined16248442unjoin_ed
unmounted1245902unmounted
unpinned1136382unp_inned
unpitted1148622unp_itted
unplanted1236852unplanted
unpoised1139182unpoi_sed
unposted1159432unpo_sted
unpotted11108392unpo_tted
unstinted1038562unstinted
untainted1038422untainted
unwonted12248642unwo_nted
anointer837823an_ointer
appointee1345003appointee
appointer1354423appointer
arointed939003_arointed
bepainted1484343bepainted
depainted1375843depainted
enjoined16215723enjoin_ed
gunpoint1146673gunpoint__
gunpoints1243273gunpoint_s
impainted1454773impainted
imprinted1445753imprinted
jointed15378503__jointed
mispointed1545573mispointed
outpainted1344323outpainted
painted104214633__painted
poinded11358973__poinded
pointe84619313__pointe_
pointer93814933__pointer
pointes93216753__pointes
printed104016373__printed
repainted1277863repainted
reprinted1289043reprinted
splinted11369253_splinted
sprinted113411163_sprinted
surprinted1343693surprinted
unbitted1138213un_bitted
unblinded13295233unblinded
unboiled112410373unboi_led
unbolted1179323unbo_lted
unbonded12299763unbo_nded
unboned103014223unbo_n_ed
unbonneted1343143unbonneted
unbooted1188773unbo_oted
unbounded1335413unbounded
uncoated11314963unco_ated
uncoiled112512683uncoi_led
undaunted1145453undaunted
undented102313953un_dented
undotted1048523undo_tted
undoubted1344463undoubted
unedited10249833unedi_ted
unfitted1238163un_fitted
unfoiled12249723unfoi_led
unfounded1435363unfounded
ungifted13116833un_gifted
ungowned1335183ungown_ed
unhinged13257473un_hinged
unionised1046533unionised
unionized1946673unionized
united74421543un__i_ted
unjoint1449233unjoint__
unjoints1544433unjoint_s
unkinked12215903un_kinked
unknitted1443703unknitted
unlined82515803un_lin_ed
unlinked13237793un_linked
unlisted9311153un_listed
unlocated1238383unlocated
unmined102612953un_min_ed
unnoted8311363unno__ted
unoiled82415483un_oi_led
unopened1137023unopen_ed
unowned1148813un_own_ed
unpaired11208943unpai_red
unparted11310823unp_arted
unpenned1137543unp_enned
unpicked17237213unp_icked
unpiled102312743unp_i_led
unpitied1138793unp_itied
unplaited1236883unplaited
unplanned1244413unplanned
unpoliced1445163unpoliced
unpolished1643433unpolished
unpolite1049173unpolite_
unpolled1168943unpo_lled
unpolluted1342133unpolluted
unposed10711903unpo__sed
unpriced1338143unpri_ced
unprimed1337203unpri_med
unprized2038513unpri_zed
unprompted1743113unprompted
unpruned1136863unprun_ed
unrented92413923un_rented
unrinsed938383un_rinsed
unroasted1036613unroasted
unrooted9810513unro_oted
unrounded1135863unrounded
unscented1237513unscented
unshifted16124943unshifted
unshirted13105953unshirted
unsifted12128773un_sifted
unsoiled92412083unsoi_led
unsorted9312513unso_rted
unsounded1135543unsounded
unspoiled12255563unspoi_led
unspotted1244933unspo_tted
unsuited9310793unsui_ted
untented92613413un_tented
untilted9610893un_tilted
untinged10308943un_tinged
untwined1237063untwin_ed
untwisted1344863untwisted
ununited938683ununi_ted
unveined1258003unvein_ed
unvoiced14106303unvoi_ced
unwanted12249603un_wanted
unwitted1237543un_witted
unwounded1444623unwounded
unzoned172310653unzo_n_ed
uplifted1454423u_plifted
uplinked15254203u_plinked
uptilted1174683u_ptilted

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 Filter1786911486410.436409841.7
2DLD Change Limit1486411347.20320636.0
3Display Results1341340.0632127.0
 (SQL Overall)1786911347.70223200.6
 
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.