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

63 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
naturists94751(None) 
naturisms1146701naturisms
naturist8410811naturist_
aurists74615782_a_urists
futurists1245582futurists
nativists12116252nativists
naturalists1146442naturalists
naturism1047892naturis_m
satirists958922satirists
altruists945413altruists
amorists10411333_amorists
anatomists12116753anatomists
aneurisms1145633aneurisms
antirusts948143antirusts
aorists74215833_a_orists
aquarists1856123_aquarists
atavists1137583_atavists
atheists1138713_atheists
atomists102610963_atomists
attrits7310613_attri_ts
aurist65027253_a_urist_
auteurists1045093auteurists
autists73814853_a_utists
casuists1036523casu_ists
culturists1245413culturists
denturists1145353denturists
fabulists1444723fabulists
fatalists12310023fatalists
fauvists1443843fa_uvists
futurisms1444533futurisms
futurist1148283futurist_
jurists14409123__jurists
liturgists11113103liturgists
maturest1039693maturest_
maturity1367433maturi_ty
metrists1039853met_rists
miniaturists1452683miniaturists
motorists1149913motorists
narcists1078113na_rcists
nativisms14105993nativisms
nativist11118683nativist_
natriums1046293nat_riums
naturalises1146493naturalises
naturalisms1346503naturalisms
naturalist1048873naturalist_
naturals847903natur_als
natures7311963natur__es
nudists8356833n__udists
patriots1038053pat_riots
posturists1247073posturists
purists94014073__purists
sacrists1039563sa_crists
satanists948233satanists
satirises9410193satirises
satirist8313503satirist_
saturants946383saturants
saturnisms1243763saturnisms
sitarists949373sitarists
tourists838313_tourists
tubists9288323__tubists
turista737443__turista
turistas846693__turistas
votarists1298603votarists

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.423422437.4
2DLD Change Limit148641637.29620372.9
3Display Results63630.0302100.0
 (SQL Overall)178691637.74923059.9
 
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.