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

57 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
trimester114582(None) 
rimester1037811_rimester
trimesters1245421trimesters
trimeter10310081trime_ter
bimester1236162_bimester
rimesters1137492_rimesters
trickster15265712trickster
trimeters1139212trime_ters
arrester839253ar_rester
bimesters1336343_bimesters
diester83013683_di_ester
digester10258433_digester
dimeter10411893_dime_ter
gamester1137323_gamester
grister83915413gri__ster
kiester11329973_ki_ester
orienter838313ori_enter
orometer10310703orome_ter
oximeter1755153oxime_ter
perimeter1349563perime_ter
prester93519623pr__ester
priested1138393pri_ested
protester111510483protester
remaster10311473_remaster
rester63832433_r__ester
rhymester1742393rhymester
riveter10208753_rive_ter
semester1038903_semester
taximeter1844413taxime_ter
teamster1036293team_ster
tester64227153t___ester
thirster1135673thi_rster
timelier1036713t_imelier
timesaver1442323t_imesaver
tipster9299053t_i_pster
tormenter1146703tormenter
treater74219833tr__eater
tribesmen1342963tribesmen
tricksier15275243tricksier
tricksters16264773tricksters
trientes82812123tri_entes
trimer85717153trim___er
trimmer113610833trim__mer
trimmest12227023trimmest__
trimnesses1287753trimnesses
trimotor1044813trim_otor
trinketer1344563trinketer
trisected1244913trisected
trisector1144323trisector
triste63818643tri__ste_
triter65120593tri___ter
tritest7315273tritest__
trumpeter1343153trumpeter
truster73114313tr__uster
tryster10369513tr__yster
twister10308953twi__ster
wrester102812413wr__ester

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.436409841.7
2DLD Change Limit148641576.53322752.3
3Display Results57570.0301900.0
 (SQL Overall)178691576.99925530.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.