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

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

67 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
apiarist1041206(None) 
apiarists1147881apiarists
aviarist11410111aviarist
aphorist13412512aphorist
apiarian1048322apiarian
apiaries10312732apiaries
aquarist171010082aquarist
aviarists1246612aviarists
diarist8517112_diarist
pianist9615102_pianist
aerialist9914263aerialist
airest63825263a_i_rest
airiest74221013a_i_riest
alarmist1049123a_larmist
alienist8411993alienist
alpinist1059153alpi_nist
ambaris113112163ambaris_
amorist9317643a_morist
animalist11511643animalist
animatist11411003animatist
animist93815173ani_mist
annalist8413753annalist
aorist64827873a__orist
apart74330673ap_ar__t
aphorise1339983aphorise
aphorism1548643aphorism
aphorists1448263aphorists
apiarians1146653apiarians
apiary113910383apiar__y
apparat11711713appar_at
apparats1287093apparats
apparent1248263apparent
appraise1247703appraise
apprise11310193ap_prise
aquarists1856123aquarists
arbalist10313333arbalist
arborist10411613arborist
ascaris93613323ascaris_
atavist10311093a_tavist
aurist65027253a__urist
autarkist1345103autarkist
aviaries1139783aviaries
capitalist1457883capitalist
czarist18710223_czarist
dialist8517763_dialist
diarists9410363_diarists
guitarist10157083guitarist
lapidist1147843lapi_dist
paganist11411813paganist
papist102618753_p_apist
paris75145943_p_aris_
parish115022353_p_arish
pianism11611033_pianism
pianists1049013_pianists
pietist9414033_pietist
plagiarist13146183plagiarist
purist85525053_p_urist
racialist11411203racialist
satirist8313503sati_rist
sitarist8315283sitarist
sparest94616433sp_arest
spiriest102513463spi_riest
spirit83519923spi_ri_t
spirits94112623spi_rits
tsarist7712253_tsarist
tzarist1659103_tzarist
votarist111012163votarist

Search took 9 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.483369960.7
2DLD Change Limit146162677.97018339.0
3Display Results67670.0332030.3
 (SQL Overall)178691678.48621057.2
 
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.