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

63 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
repattern114366(None) 
repatterns1242491repatterns
pattern93712052__pattern
repatterned1452172repatterned
bespatter1343143bespatter_
bespatters1442783bespatters
betatter1035453betatter_
betatters1134963betatters
eastern74412533_e_astern
leathern11398913le_athern
pastern94415063__pastern
patten84418193__patte_n
patter84628263__patter_
patterns10439943__patterns
patters94825193__patters
ratteen7329113r__atteen
ratten64217383r__atte_n
ratter64326313r__atter_
ratters74422473r__atters
realter73716313re_alter_
realters83614043re_alters
reattain846733re_attain
rebater93517913reba_ter_
rebaters103413943reba_ters
rebutter10106273rebutter_
rebutters1195093rebutters
recanter101913153recanter_
recanters112310483recanters
refasten1136103refaste_n
regather1236733regather_
regathers1336353regathers
relater73723143rela_ter_
relaters83218153rela_ters
reletter81311023reletter_
reletters9138783reletters
remaster10311473remaster_
remasters11310583remasters
remitter102810323remitter_
remitters11328403remitters
repairer1036783repairer_
repairers1135283repairers
repaper11310023repa_per_
repapers1258833repa_pers
repartee10312753reparte_e
repartees1147253repartees
repasted112611533repaste_d
repatterning1552173repatterning
repeater102615443repeater_
repeaters112811993repeaters
repenter102813863repenter_
repenters112511553repenters
replaster1136583replaster_
replasters1245533replasters
reporter10411423reporter_
reporters1139173reporters
repotted1139283repotte_d
resetter81511833resetter_
resetters9129463resetters
reutter71010093re_utter_
reutters8138573re_utters
slattern837093_slattern
spatter94016523_spatter_
spatters103914703_spatters

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.440406115.9
2DLD Change Limit148641637.82618993.2
3Display Results63630.0163937.5
 (SQL Overall)178691638.28221575.8
 
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.