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 “preunited” 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
preunited124680(None) 
preunite1039571preunite_
preunites1138931preunites
reunited939711_reunited
precited133013812pre_cited
preedited1337632preedited
preinvited1663922preinvited
reunite7312712_reunite_
reuniter838322_reuniter
reunites8312472_reunites
arenite71017713are_nite_
arenites8917103are_nites
braunite1047253braunite_
braunites1146723braunites
bruited104110353br_u_ited
credited1238253cre_dited
crenated113013913cre_nated
disunited1177273disunited
fruited11389093fr_u_ited
grunted9339283gr_un_ted
lenited8812433_le_nited
parented11912213pare_n_ted
pennated11299543p_ennated
perennated1345693perennated
preacted132710943pre_acted
preboiled1455783preboiled
precented14310693precented
precised133213413pre_cised
preconized2467143preconized
predated12513273pre_dated
predicted1538913predicted
predried12309573predri_ed
preempted1644683preempted
preenacted1544973preenacted
preened103214983preen__ed
preexcited2243503preexcited
preexisted2043783preexisted
prefiled143310573pre_filed
prefired144310753pre_fired
prefixed21357693pre_fixed
prefunded1644693prefun_ded
preguided1443923preguided
preheated1539813preheated
preinvite1485443preinvite_
preinvites1564803preinvites
prejudiced2342543prejudiced
prelected1439123prelected
prelimited1545493prelimited
premised133013193pre_mised
premixed20338003pre_mixed
prenticed14118063prenticed
prepasted14137663prepasted
prepriced1676633prepriced
preprinted1546543preprinted
prepunched2073113prepunched
prerinsed1246323prerinsed
presented12311633presented
presided12410553pre_sided
presifted1536873presifted
presliced1435973presliced
presorted1239453presorted
pretasted12147963pretasted
pretested12149113pretested
pretexted19135683pretexted
prettied1159253pretti_ed
preunion1046893preuni_on
preunions1146483preunions
preuniting1347303preuniting
prevailed1536043prevailed
prevented1539003prevented
prevised143611073pre_vised
previsited1645183previsited
prewired14358473pre_wired
printed104016373pr_in_ted
profited14279973pr_ofited
pronated11414053pr_onated
pruned93413113pr_un__ed
punted94618713p__un_ted
rebaited11410543_rebaited
recited104319103_re_cited
reedited10310083_reedited
reignited1145683_reignited
reincited1246853_reincited
reinvited1386193_reinvited
reknitted1444023_reknitted
reminted113615083_reminted
rented74426593_re_n_ted
requited18169723_requited
resited85122423_re_sited
respited11410813_respited
retinted94414363_retinted
reunified1346593_reunified
reuniters936423_reuniters
united74421543___united
ununited938683_ununited

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.1561145455.1
2DLD Change Limit148641957.50019818.8
3Display Results95950.0332878.8
 (SQL Overall)178691957.68923239.8
 
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.