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

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

165 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
distrainers125505(None) 
distrainer1146431distrainer_
distrainors1252921distrainors
dispraisers1443422dispraisers
distrained1257672distraine_d
distrainor1163392distrainor_
distrains10411332distrain__s
distraints1166872distrain_ts
restrainers1145122restrainers
strainers9510382__strainers
abstainers1243453abst_ainers
destriers1038143destr_i_ers
detainers10269103d_et_ainers
disclaimers1653133disclaimers
disgracers1444733disgra_cers
dispraiser1345103dispraiser_
dispraises1347393dispraise_s
distained1139603dist_aine_d
distains9413603dist_ain__s
distrain9412243distrain___
distraining1346983distraining
distraint101112903distrain__t
distraite10611483distraite__
drainers92811253d___rainers
entrainers1086963_entrainers
mistrained1347583mistraine_d
mistrains11511353mistrain__s
restrainer1046973restrainer_
stainers83212173__st_ainers
strainer8512223__strainer_
sustainers1044133sust_ainers
trainers83114643___trainers
abstainer1144404abst_ainer_
abstracters1544104abstracters
airliners945984ai__rliners
attainers9115594__attainers
castraters1246474castra_ters
citrines102513134ci_tr_ine_s
containers1249904cont_ainers
describers1543584descr_ibers
descriers1245694descr_i_ers
despairers1343104des_pairers
destained1158254dest_aine_d
destains9311814dest_ain__s
destines93619664dest__ine_s
destrier9311824destr_i_er_
destroyers1443644destr_oyers
detailers10257254d_et_ailers
detainees10267154d_et_ainees
detainer92910794d_et_ainer_
determiners1444644determiners
detrained1158914d_etraine_d
detrains9411764d_etrain__s
dextrines1798314dextr_ine_s
diatribes1245534diatr_ibe_s
dietaries10410664dietari_e_s
dirtiness1039474di__rtiness
disablers1255804dis__ablers
disarmers1246944dis__armers
disasters1039154dis__asters
discarders1445044dis_carders
discerners1345704dis_cerners
dischargers1873064dischargers
discipliners1752814discipliners
disclaimer1543954disclaimer_
disdained1246024dis_daine_d
disdains1037914dis_dain__s
disgracer1346184disgra_cer_
disgraces1348454disgra_ce_s
disguisers1244034dis_guisers
dishwashers2151604dishwashers
dishwaters1744024dishwa_ters
disinters1039714dis___inters
dislikers14286424dis__likers
dismalness1344044dis_malness
disorders1146964disor__ders
disorients1177794disor_ients
disparagers1553394disparagers
displacers1545014displa_cers
displayers1654824displa_yers
dispraise1248344dispraise__
dispraised1446404dispraise_d
disprizes2148114dispr_ize_s
disprovers16145284dispr_overs
disrates91118154dis_ra_te_s
disrobers1246384dis_r_obers
disrupters1343934dis_rupters
dissuaders1273834dissua_ders
distain8313784dist_ain___
distaining1248904dist_aining
distances12311654dist_a_nces
distantness1254334distantness
distastes1039634dist_aste_s
distaves12311404dist_a_ve_s
distempers1544294dist_empers
distenders12166734dist_enders
distillers1145124dist_illers
distorters1147164dist_orters
distracted1448874distracte_d
distracts1249284distra__cts
distrainable1553634distrainable
distrait9414344distrai___t
distress9311714distr___ess
distresses1148854distresse_s
districts1248934distr_i_cts
disturbers13164164dist_urbers
disuniters11104734dis_uniters
ditsiness1048144di_t_siness
dittanies1045734di_ttanie_s
ditziness1945884di_t_ziness
diviners12308354di___viners
doctrines1247154doctr_ine_s
drainer83012844d___rainer_
dustiness102211034dust__iness
entrainer968584_entrainer_
estrangers11376104_estrangers
grainers93012074___grainers
histamines1575894histamine_s
histidines1444534histidine_s
interliners11138694_interliners
intranets949264_intra_nets
listeners9147324list__eners
maintainers1352834maint_ainers
migraines1286934mi_graine_s
miserliness1344914miserliness
misprizers2344014mispr_izers
misraises1149934mis_raise_s
mistakers15117084mist_a_kers
mistiness111911634mist__iness
mistraces13312294mistra_ce_s
mistrain10311944mistrain___
mistraining1446504mistraining
obtainers1144854_obt_ainers
pistoliers1244584pistoli_ers
postriders1344854postr_iders
refrainers1344474_refrainers
restrained1148414restraine_d
restrains9311624restrain__s
restraints1056604restrain_ts
retainers92510764_ret_ainers
retrainees1046394_retrainees
stainer73614924__st_ainer_
strafers11379914__stra_fers
strained9412254__straine_d
strains74218154__strain__s
straitens946234__straitens
straiter8311784__straiter_
straitness1046294__straitness
stranders10389934__stranders
strangers104112164__strangers
strappers1346744__strappers
strayers113510144__stra_yers
striders94412124__str_iders
strikers123611294__str_ikers
stringers104210644__str_ingers
stripers103911594__str_ipers
strivers113911844__str_ivers
sustainer944784sust_ainer_
trailers82912924___trailers
trainees82712064___trainees
trainer73316794___trainer_
unstrained1146374unstraine_d
vitrains1138284vi_train__s
vitrines112610914vi_tr_ine_s
wintriness1345544wintr_iness

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 Filter1786911488190.423422437.4
2DLD Change Limit1488191658.32617874.0
3Display Results1651650.0961718.8
 (SQL Overall)1786911658.84520202.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.