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

79 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
sergeanties125374(None) 
sergeancies1444391sergeancies
serjeanties1852641serjeanties
sergeants10115592sergeant__s
serenities10411073ser_enities
sergeant9129403sergeant___
sergeanty13104163sergeant__y
serjeants1673963serjeant__s
serpentines1355313serpe_ntines
seventies1249673se_ve_nties
argentines1146954_arge_ntines
argentites1147034_arge_ntites
certainties1353764certainties
eglantines1143674_e_glantines
elegancies1345014_elegancies
emergencies16124514emerge_ncies
ergates8314494_erg_a_t_es
ergatives1346444_erg_a_tives
errancies1147964_er_rancies
errantries1044944_er_rantries
fervencies1845184ferve_ncies
furmenties1544864furme_nties
heredities1447224her_edities
legerities1196884le_gerities
mercenaries1555444mercenaries
mergences14137554merge_n_ces
morganites1346724morg_anites
organdies1187214_org_andies
pageantries1452984_pageantries
percentiles1546204perce_ntiles
permeances1645654permean_ces
permeates13311774permea_t_es
pregnancies1644564pregnancies
realties8514854__r_ealties
recreancies1544654recreancies
regencies1249284re_ge_ncies
regnancies1345414re_gnancies
scanties103215424s___canties
segregants1242704segregant__s
segregates1245344segregat_es
selenates91611364se_lenat_es
selenites91312094se_le_nites
semantics1346824se__mantics
septenaries1375354septenaries
sequencies2155994seque_ncies
serenades10217944ser_e_nades
serenatas9145204ser_enat_as
serenate81914884ser_enat_e_
serenes73222904ser_e_n__es
sergeancy15113624sergean__cy
seriates82620684ser_ia_t_es
serigraphies18114764serigraphies
serjeant1596474serjeant___
serjeanty19122724serjeant__y
serosities10410824ser_osities
serotinies1047444serotin_ies
serpentine1246224serpe_ntine
serpents102410374serpe_nt__s
serranids1045534ser_ran_ids
serrates82617024ser_ra_t_es
servantless1451544ser_vantless
servants1138004ser_vant__s
servilities1447054servilities
severalties1453664severalties
severities1348524se_verities
shanties113116594s___hanties
shrievalties186794shrievalties
sirventes1244914sirve_nt_es
sovranties1343844s_ovranties
stagnancies1452664stagnancies
sureties8316584sur_e__ties
surgeries10311364surge__ries
treaties8316984_tr_ea_ties
turgencies1345514turge_ncies
urgencies1256644_urge_ncies
vengeances1643644vengean_ces
verdancies1645234ver_dancies
vergences15128064verge_n_ces
warranties1344684war_ranties

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 Limit148819798.87316772.1
3Display Results79790.0332393.9
 (SQL Overall)178691799.34619119.5
 
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.