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 “prearrangementsa” with Change Limit: [1] [2] [3] [4] [5] [6] [7] [8]

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

83 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
prearrangements2071701prearrangements_
prearrangement1971872prearrangement__
rearrangements17173002_rearrangements_
rearrangement16173223_rearrangement__
arrangements1554324___arrangements_
disarrangements1972704disarrangements_
arrangement1454835___arrangement__
derangements1665825_de__rangements_
disarrangement1872925disarrangement__
estrangements1684405__estrangements_
prearranges1453045prearrang__e__s_
arraignments1553166___arraignments_
derangement1556466_de__rangement__
embranglements21132536__embranglements_
entrancements17105176__entrancements_
estrangement15105116__estrangement__
prearrange1353226prearrang__e____
prearranged1552706prearrang__e___d
prearranging1652656prearrang__in__g
preordainments1981516preorda_inments_
pretreatments1752496pretrea__tments_
ravagements1754166_r_a_va_gements_
rearguments1483846_rea_r__guments_
rearmaments1554266_rearma___ments_
rearranges1145116_rearrang__e__s_
reengagements1752746_reenga_gements_
abridgements1853047___abridgements_
advancements2052817___advancements_
arraignment1453617___arraignment__
bereavements19154207_be_rea_vements_
carrageens1363307__carra_ge_en_s_
comanagements2062737coma_na_gements_
depravements2054457_de_pra_vements_
dethronements1962777_dethron_ements_
disparagements2063487dispara_gements_
embarrassments20111827embarra_ssments_
embracements2055247__embra_cements_
embranglement20122887__embranglement__
encouragements1962177encoura_gements_
endangerments1772477__e_ndangerments_
enframements1954627__enfra_mements_
engagements1546507__e_nga_gements_
enhancements1954897__e_nhancements_
enlargements1555197__e_nlargements_
entanglements1653707__e_ntanglements_
entrancement1686137__entrancement__
infringements1963357__infringements_
managements1655317__ma_na_gements_
paramenta1368867p__a_ra___ment_a
paraments13511557p__a_ra___ments_
parrakeets1652367p__arra_ke_e_ts_
permanents1455457p_e_rman___ents_
preachments2044237pre___a_chments_
predicaments1953227predica___ments_
preferments1844747prefer____ments_
prefigurements2261247pre_figurements_
prejudgments2551847pre__judg_ments_
preordainment1881877preorda_inment__
prepayments2053337pre__pa__yments_
preretirement1762717pre_retirement__
presentiments1753027pre__sentiments_
presentments1654307pre__sen_tments_
pretreatment1653277pretrea__tment__
procurements1852917procur___ements_
pronouncements2071867pr_onouncements_
ravagement1644987_r_a_va_gement__
realignments1553297_rea__lignments_
reargument1374667_rea_r__gument__
rearmament1455387_rearma___ment__
rearrange1045047_rearrang__e____
rearranged1244107_rearrang__e___d
rearranging1343787_rearrang__in__g
reassignments1662117_rea_ssignments_
reattachments2062087_reatta_chments_
recrements1449357_re_cr___ements_
reengagement1653087_reenga_gement__
refinements1646797_re__fin_ements_
refrainments1754007_re_fra_inments_
renouncements17163907_re_nouncements_
replacements1854447_re_pla_cements_
restatements1455287_re_sta_tements_
retirements1357617_retir___ements_
retrenchments2062577_re_trenchments_

Search took 9 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 Filter178691950240.403443402.0
2DLD Change Limit95024838.44011258.8
3Display Results83830.0631317.5
 (SQL Overall)178691838.90620064.1
 
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.