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

(Found more than 100 similar words, so Change Limit cannot be increased.)
to automatically search another random word after seconds.

143 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
regiment11441405(None) 
regimen104411571regimen_
regimens11469231regimens
regiments123910321regiments
pediment13411392pediment
raiment9315412r_aiment
recement12315652recement
regent74127672reg__ent
regime95313942regime__
regimental13115762regimental
regimented1444912regimented
regimes104514742regime_s
regiven11478322regiven_
remitment1349442remitment
renitent8315332renitent
repigment1447922repigment
resident9313752resident
reticent10313292reticent
rudiment1147662rudiment
sediment11411102sediment
segment10312562seg_ment
tegument1177522tegument
aliment9316703_aliment
argument1158903argument
augment10910203aug_ment
cement103321673ce__ment
cerement12315133cerement
dement93825153de__ment
desinent9312963desinent
detriment1249693detriment
devilment1547713devilment
diriment11410743diriment
element9317803_element
eminent9313853_eminent
evident1139993_evident
exigent1539513_exigent
ferment12315573fe_rment
figment1379743fig_ment
fragment1448373frag_ment
hegumen1355463hegumen_
hegumene1443983hegumene
hegumens1444303hegumens
hegumeny1742903hegumeny
legmen939343leg_men_
lenient7313843leni_ent
ligament1149313ligament
liniment1049533liniment
merriment1358023merriment
muniment1248943muniment
negligent1144193negligent
orpiment1247973orpiment
pediments1448343pediments
penitent10413503penitent
pigment12510733pig_ment
president12410993president
ragmen93712183rag_men_
raiments1039903r_aiments
reaccent1278573reaccent
reagent8716603re_agent
reargument1374663reargument
reascent10411983reascent
reblent9614253re_blent
recements13312283recements
recent83630853re__cent
recipient1348023recipient
recrement13411363recrement
recumbent1545323recumbent
redigest1039733redigest
redirect11147993redirect
redolent9411883redolent
reedmen1038333reedmen_
referent112813423referent
refinement1548193refinement
refluent1147433refluent
regents83416543reg__ents
regilt71217493regi__lt
regimentals1494653regimentals
regimenting1544663regimenting
regina75317143regi__na
region74614903regi_on_
regions83613473regi_ons
regive104814323regive__
regives115014213regive_s
regiving13269713regiving
reglet73724233reg_le_t
regnant8312843reg_nant
regrant8317323reg_rant
regreen8309043regreen_
regreens9257453regreens
regreet83015953reg_reet
regret73723533reg_re_t
reinvent1138903reinvent
relent64431853re__lent
reliant7319243reli_ant
relucent1049283relucent
remanent10311703remanent
remeet86325473re__meet
remelt85123123re__melt
remend95216553re__mend
remet74843723re__me_t
remint85329983re__mint
remitments1446843remitments
remittent1148273remittent
reorient8613473reorient
repayment1646343repayment
repent84728873re__pent
repigments1546343repigments
rerent63832453re__rent
rerisen73613643rerisen_
resent63833623re__sent
residents1038423residents
resilient9410113resilient
resmelt9411773re_smelt
retime85321803retime__
retimed104714653retime_d
retimes95020173retime_s
retiming113014193retiming
retinene839803retinene
retint65633443reti__nt
retirant8313593retirant
retirement1259123retirement
revehent14239083revehent
revelment1448773revelment
reverent112615093reverent
revetment1448323revetment
revilement1548483revilement
rewiden1137533rewiden_
rewidens1235533rewidens
rident7520193r__ident
rudiments1245823rudiments
sediments1248213sediments
segments1138903seg_ments
sentiment11410723sentiment
tegmen988403teg_men_
tegmenta1155613teg_menta
tegumen10105423tegumen_
teguments1265453teguments
tenement10412593tenement
treatment1148183treatment
vehement1647763vehement
vestment13109203vestment
weldment1445823weldment
yeggmen1442673yeggmen_

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.420425454.8
2DLD Change Limit1461621437.50019488.3
3Display Results1431430.0632269.8
 (SQL Overall)1786911437.98322383.9
 
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.