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 “serviceable” with Change Limit: [1] [2] [3] [4] [5]

You can choose a higher Change Limit to return more words, although it will take longer.
to automatically increase the Change Limit after seconds.

71 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
serviceable185240(None) 
serviceably2152001serviceably
unserviceable2062072unserviceable
disserviceable2211803disserviceable
priceable1546823_pr_iceable
servable13310093serv___able
sliceable1345443s__liceable
survivable1842953survi_vable
certifiable1852914certifiable
cervical1546854cervic_a_l_
derivable1548064der_i_vable
despicable1744984despic_able
devisable1546854de_vi_sable
driveable1544524_dr_iveable
effaceable2042264_effaceable
enviable1337854_envi__able
eradicable1545634_eradic_able
erectable131210094_er_ectable
evitable1339324_e_vi_table
evocable1537104_e_voc_able
forceable1646214for__ceable
heritable1439454her_i_table
leviable1337514le_vi__able
medicable1647504me_dic_able
noticeable1443714_noticeable
peaceable1548254pe__aceable
perishable1745264per_ishable
permeable1556824per__meable
predicable1747194predic_able
predictable1844994predictable
previable1647544previ__able
raiseable1147244__raiseable
replaceable1743224replaceable
replicable1646624replic_able
reviewable1843434re_viewable
revisable1437994re_vi_sable
revivable1736864re_vi_vable
revocable1647004re_voc_able
rideable1158654__r_ideable
salvageable1751434salvageable
saveable1339004s_av__eable
searchable1744144se_archable
seeable91113944se____eable
seisable10311374se__i_sable
seizable1938724se__i_zable
selectable14136444se_lectable
service1239094servic____e
serviceability2462864serviceability
serviceableness2262034serviceableness
serviced1435614service___d
serviceman1751884service_man
servicemen1752334service_men
servicer1335264service___r
servicers1444664service__rs
services1338574service___s
servicewomen226994servicewomen
serviette1242964servi_e_tte
servile10310644servi____le
servilely1543804servile__ly
settleable1242584se_ttleable
severable1438544se_v_erable
shrinkable1942494shr_inkable
sizeable1937114s___izeable
stickable1745544s__tickable
stretchable1852814stretchable
strippable1642664str_ippable
terminable1476604termi_nable
traceable1338324_tr_aceable
verifiable1843684ver_ifiable
veritable1448744ver_i_table
writeable1444614_wr_iteable

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 Filter1786911488190.440406115.9
2DLD Change Limit148819718.70317099.7
3Display Results71710.0461543.5
 (SQL Overall)178691719.18919446.2
 
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.