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

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

61 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
ordainments145354(None) 
ordainment1354141ordainment_
obtainments1553492obtainments
arraignments1553163arraignments
attainments1353943attainments
containments1655783containments
detainments1485893detainments
obtainment1454313obtainment_
ordainers1055113ordain_e_rs
ornaments1146633orna__ments
orpiments1346003or_pi_ments
preordainments1981513preordainments
raiments1039903_r_ai_ments
adornments1345164_adornments
ailments1039434___ailments
armaments1347474arma__ments
arraignment1453614arraignment_
attainment1255014attainment_
bailments1346464__bailments
condiments1548194cond_i_ments
containment1557444containment_
curtailments1652024curtailments
derailments1446104derailments
detainment1377144detainment_
detrainments1574654detrainments
edutainments1552494edutainments
eloinments1245994_eloinments
enchainments1953484enchainments
entailments1346354entailments
entrainments1465454entrainments
fragments1546214fr_a_gments
gradients1145274gradi__ents
hardiments1644534hard_i_ments
impairments1753874impairments
oddments1244104o_d__dments
ointments1166654o___intments
ordained1035184ordain_e__d
ordainer945224ordain_e__r
ordaining1145754ordain_in_g
ordains879654ordai___n_s
ordinands1143034ord_in_ands
ordines83014904ord_in_e__s
orients7311584or__i__ents
ornament1049134orna__ment_
orpiment1247974or_pi_ment_
pediments1448344ped_i_ments
preachments2044234preachments
preordainment1881874preordainment_
raiment9315414_r_ai_ment_
realignments1553294_realignments
refinements1646794_refinements
refrainments1754004refrainments
regiments123910324_regi_ments
reinvents1246124_r_einvents
remitments1446844_remitments
repigments1546344_repigments
rudiments1245824_rudi_ments
sediments1248214sed_i_ments
trainmen1046154tr_ainmen__
treatments1246284trea_tments
worriments1544154wor_ri_ments

Search took 10 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 Filter1786911488190.423422437.4
2DLD Change Limit148819619.14016282.2
3Display Results61610.0331848.5
 (SQL Overall)178691619.59618621.4
 
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.