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

95 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
audients94635(None) 
audient8312301audient_
advents11309472a_dvents
ambients1246052ambients
ancients1098972ancients
audience1146582audience
audiences1246002audiences
audings9289392audi_ngs
audits72814112audi__ts
augments1137832augments
rudiments1245822rudiments
abluents1045463abluents
absents93510723a_bsents
abutments1345283abutments
accents113511233a_ccents
accidents14155133accidents
addends10356053a_ddends
addicts1176013addi_cts
adepts9117103a_d_epts
adieus739633a_die_us
adits66523713a_di__ts
advects13276013a_dvects
advent102613753a_dvent_
adverts11308513a_dverts
affiants1445233affiants
agents74816293a__gents
ailments1039433ailments
aliens65619213a_lien_s
aliments10311093aliments
ambient11310093ambient_
aments85219803a__ments
ancient9514733ancient_
anoints7311063anoi_nts
aperients1178253aperients
ardent73022613ard_ent_
argents84014853a_rgents
aroints7313133aroi_nts
arpents93613083a_rpents
ascents93812553a_scents
assents74512223a_ssents
audibles11215533audibles
audiles83112613audi_les
auding83616933audi_n_g
audios72312283audi__os
audit62527883audi__t_
auditees946463auditees
auditors947613auditors
augends935883au_gends
augment10910203augment_
auklets11298573aukle_ts
aunts55227633au___nts
aurists74615783auri_sts
autists73814853auti_sts
auxins13129813auxi_n_s
budgets11489863budge_ts
clients938093_clients
currents1038373currents
dents65031803__d_ents
dienes75719903__dienes
diets66026643__die_ts
dints67431313__di_nts
dudeens934863dudeen_s
gaudies9311973gaudie__s
gaudiest1039393gaudiest_
gaudiness1136253gaudiness
gradients1145273gradients
hardiments1644533hardiments
hutments1345603hutments
indents83114663ind_ents
indigents11208273indigents
judgments2043253judgments
mediants11299493mediants
mudhens1335103mudhen_s
muniments1346143muniments
nudies75217093nudie__s
nudists8356833nudi_sts
nutrients944423nutrients
oddments1244103oddments
orients7311583_orients
patients1088763patients
pediments1448343pediments
quiets154014373qu_ie_ts
quints154316563qu_i_nts
quotients1843023quotients
radiants9259443radiants
rodents8611543rod_ents
rudiment1147663rudiment_
salients839563salients
sapients1037423sapients
sediments1248213sediments
students954683stud_ents
subrents10310293subrents
suddens9308783sudden_s
suints64617783su_i_nts
tridents938583tridents

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 Filter1786911461620.436409841.7
2DLD Change Limit146162957.25020160.3
3Display Results95950.0303166.7
 (SQL Overall)178691957.71623158.5
 
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.