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

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

69 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
schoolmasters206197(None) 
schoolmaster1962141schoolmaster_
schoolmasterish2581002schoolmasterish
schoolmasterly2410932schoolmasterly
schoolmates1853632schoolma_te_s
choirmasters1952263_choirmasters
schoolmate1753323schoolma_te__
schoolmistress217823schoolmistress
scoutmasters1652513sc_outmasters
choirmaster1852134_choirmaster_
scholastics1854134sch_ol_astics
scholiasts1544094sch_oliast__s
schoolmarm1951974schoolma___rm
schoolmarms2051804schoolma__rms
schoolteachers2411674schoolteachers
scoutmaster1562494sc_outmaster_
shipmasters1852864s_h_ipmasters
whoremasters2052714_whoremasters
burgomasters1751455burgo_masters
chocolates1746775_chocol_a_te_s
chocolatiers1971595_chocol_atiers
cholates132414765_ch_ol_a_te_s
choosers134810875_choo___s_ers
choristers1586105_ch_o_risters
chromates16313105_chro_ma_te_s
coasters104317335_c__o__asters
cotoneasters1452315_cotoneasters
dockmasters2053105__dockmasters
doomsters1236175__doo_m_sters
drillmasters1551295_drillmasters
harbormasters2061295harbormasters
headmasters17174305__headmasters
holsters113211945__h_ol__sters
hoopsters1445685__hoo__psters
housemasters17153625__housemasters
ironmasters13163265__ironmasters
loadmasters1453315__loadmasters
oleasters936735____oleasters
outmasters1245735___outmasters
postmasters15115325__postmasters
sandblasters1552155sandbl_asters
scamsters1334995sc___am_sters
schmattes1644325sch___matte_s
scholars1336685sch_ol_a___rs
scholastic1745865sch_ol_ast_ic
scholiast1446305sch_oliast___
scholiastic1854105sch_oliast_ic
schoolbags1852145schoolba___gs
schoolhouses2052055schoolhouse_s
schoolman1642995schoolma____n
schoolmarmish257875schoolmarmish
schoolmen1643475schoolm___e_n
schoolteacher239775schoolteacher_
schooltimes1852605school_time_s
schooners1445665schoo____ners
scooters103511035sc_oo____ters
shinplasters1751855s_hinplasters
shipmaster1742965s_h_ipmaster_
shoemakers1943495s_h_oema_kers
shooters112811585s_hoo____ters
shoplifters1951765s_hopl_ifters
soulmates1147075s__oulma_te_s
spymasters1742805s___pymasters
stationmasters166715stationmasters
toolmakers1643015__toolma_kers
upholsters1542735uph_ol__sters
wharfmasters2351705_wharfmasters
whoremaster1952775_whoremaster_
zoolaters1844985__zool_a_ters

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 Filter1786911247900.1401276364.3
2DLD Change Limit124790699.23613511.3
3Display Results69690.0302300.0
 (SQL Overall)178691699.40618997.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.