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 “prerinsed” 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.

98 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
prerinsed124632(None) 
prerinse1038631prerinse_
prerinses1138811prerinses
precised133213412preci_sed
premised133013192premi_sed
preprinted1546542preprinted
prevised143611072previ_sed
beringed1298173_beringed
eternised10116273eternised
peined94918843p_e_in_ed
peised94817683p_e_i_sed
perfused1445843p_erfused
periled10316323p_eri_led
perilled11410113p_erilled
perinea9313033p_erin_ea
perished14310093p_erished
perused103112203p_er_used
poetised1138523poeti_sed
praised104214813pr_ai_sed
prebilled1445063prebilled
prebind123810643prebin__d
precented14310693precented
precessed1437523precessed
precise113518173preci_se_
preciser123411663preci_ser
precises123218333preci_ses
precited133013813preci_ted
precreased1544423precreased
predicted1538913predicted
predinner1245133predinner
predried12309573predri__ed
predrilled1443453predrilled
preened103214993pre_en_ed
prefiled143310573prefi_led
prefilled1535513prefilled
prefired144310753prefi_red
prefixed21357703prefi_xed
prefranked2042773prefranked
prefunded1644693prefunded
preinsert1148573pre_insert
premiered14237093premiered
premise113818553premi_se_
premises123018273premi_ses
premisses13288763premisses
premixed20338013premi_xed
preowned1435213preown_ed
prepense12238943prepense_
prepriced1676643prepri_ced
prerinsing1347643prerinsing
prescinded1644343prescinded
presented12311633presented
presided12410553presi_ded
presifted1536873presifted
pressed103317313pre__ssed
pretended1337193pretended
pretense10199823pretense_
pretenses112210593pretenses
pretrained1357063pretrain_ed
pretrimmed1742633pretrimmed
preunited1246803preunited
prevented1539003prevented
previewed1843423previewed
previse123713793previ_se_
previses133814283previ_ses
prewired14358473prewi_red
prinked143412163p__rinked
printed104016373p__rinted
prised94322203p__ri_sed
prissed103311263p__rissed
promised133010883promi_sed
propined133111513propin_ed
pterins9812993pterins__
refined114720003_refin_ed
rehinged1336853_rehinged
reined74425523_re_in_ed
reinked1239793_re_inked
relined85321933_relin_ed
relinked1337003_relinked
reminded123411523_reminded
reminted113615083_reminted
remised103516843_remi_sed
repined104918773_repin_ed
repinned1157473_repinned
reprinted1289043_reprinted
reprised112012213_repri_sed
reraised9312363_reraised
rerented92516163_rerented
rerigged1136243_rerigged
rerise64325633_reri_se_
rerisen73613643_reri_sen
rerises73525883_reri_ses
resined84522653_resin_ed
retinted94414363_retinted
retinued95210823_retinued
revised113815483_revi_sed
rewinded13277673_rewinded
rinsed75016353___rinsed
unrinsed938383_unrinsed

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 Filter1786911486410.420425454.8
2DLD Change Limit148641988.16018215.8
3Display Results98980.0462130.4
 (SQL Overall)178691988.62620715.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.