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

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

78 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
trusted8341278(None) 
crusted103712751crusted
rusted75020921_rusted
thrusted1265221thrusted
trussed84010011trussed
trustee73514441trustee
trusteed9346531trusteed
truster73114311truster
trysted11428271trysted
bruited104110352bruited
brushed133811212brushed
bruted95113262bru_ted
bursted1039422bursted
busted95123152_busted
crested103416532crested
crushed134111962crushed
dusted83918372_dusted
entrusted1065942entrusted
eructed10228652eructed
erupted10207162erupted
frosted113211872frosted
fruited11389092fruited
grunted9339282grunted
gusted84316722_gusted
intrusted1076902intrusted
jousted15339142jousted
justed144215772_justed
lusted74319442_lusted
musted93321072_musted
ousted73720582_ousted
rested74430782_rested
rousted84013322rousted
rushed104419862_rushed
rustled83311322_rustled
rutted74518402_rutted
strunted957242strunted
strutted946342strutted
tasted74123972t_asted
taunted84310962taunted
tauted75317112tau_ted
tested74421522t_ested
thruster1135792thruster
toasted84011922toasted
toused74122012tous_ed
tousled84710362tousled
touted74419742tou_ted
trashed113514692trashed
treated83618702treated
tressed83714252tressed
triste63818642triste_
trotted83711282trotted
truanted935372truanted
truced95312052tru_ced
trucked143910812trucked
trudged10298042trudged
trued65117692tru__ed
trumped12439712trumped
trunked12358412trunked
trusser74010252trusser
trusses73813632trusses
trust55426852trust__
trustees8339322trustees
trusters83112242trusters
trustier8268682trustier
trusties82712852trusties
trustor7238402trustor
trusts64714432trust_s
trusty94710112trust_y
tryste9399582tryste_
tryster10369512tryster
trystes10419992trystes
tufted10359282t_ufted
tushed104615892t_ushed
tusked114112152t_usked
tutted75117442t_utted
twisted11277432twisted
unrusted92310352unrusted
wrested113410932wrested

Search took 5 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 Filter1786911076710.1401276364.3
2DLD Change Limit107671783.84328017.4
3Display Results78780.0164875.0
 (SQL Overall)178691783.99944683.9
 
Comments and Suggestions welcome: FaceBook ~ UserVoice ~ SQLServerCentral  |  Developed By: Tom Keller Consulting © 2011-2024  |  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.