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

185 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
restation931691(None) 
gestation10310661gestation
restations10315841restations
cessation1176852cessation
dentation10315242dentation
fetation11613142fe_tation
forestation1447002forestation
gestations1139772gestations
gustation1047962gustation
hesitation1349632hesitation
mentation11313982mentation
peltation11312962peltation
recitation12315942recitation
reflation12412332reflation
refutation1349912refutation
relation82619772re_lation
reputation12411882reputation
resection111613272resection
restating102319412restating
restationed1244372restationed
restoration11412092restoration
rotation81615452r_otation
station72717242__station
aeration8319933ae_ration
aestivation1447923aestivation
agitation10311223agitation
attestation1145183attestation
betatron1045233be_tatron
caseation1199513caseation
cassation1197913cassation
castration12410803castration
cessations1256473cessations
citation10314363_citation
creation102816513cre__ation
cremation13511643cre_mation
crenation11412923cre_nation
crepitation1548393crepitation
dealation10313003dealation
deflation13310653deflation
degustation1345633degustation
delation92318083de_lation
denotation11311083denotation
dentations11413633dentations
dentition1049633dentition
deputation1339393deputation
desertion10410203desertion
desolation11311403desolation
destain8412083desta_i_n
destination12413843destination
detestation1248363detestation
devastation1546733devastation
deviation13312393deviation
dictation12810563dictation
dotation91412733_dotation
elation73620453_e_lation
enation73419233_e_nation
equation17310483_equation
eructation1248333eructation
estating92614993_estating
estimation12410843_estimation
estivation1349813_estivation
fellation1238843fellation
fetations12511383fe_tations
flotation1267813flotation
forestations1546323forestations
frustration1444813frustration
gelation93014433ge_lation
gemmation1445963gemmation
gestating11229983gestating
gestational1245113gestational
gestative1347303gestative
gustations1147233gustations
guttation1046173guttation
hebetation1557093hebetation
hesitations1448543hesitations
imitation11510853imitation
infestation1447043infestation
irritation1048973irritation
jactation1838143jactation
lactation11310813lactation
legation92412933le_gation
levitation1349443levitation
lustration1048353lustration
mediation12312293mediation
meditation13410743meditation
mentations12312583mentations
molestation1365963molestation
mutation101412883_mutation
natation81513933_natation
negation92913023ne_gation
nervation12610243nervation
nictation1189273nictation
notation81414603_notation
nutation81513103_nutation
nystatin1145093nystati_n
orientation1147573orientation
outstation1046163outstation
peltations12311553peltations
petition10711753pe_tition
potation101716783_potation
predation12313463pre_dation
presentation1448993presentation
prostration13410793prostration
protestation1456363protestation
quotation18146973quotation
radiation10313393radiation
ration64226013r___ation
reaction10612603re_action
reattain846733reattai_n
recantation1349863recantation
recaution1148093recaution
reception13410323reception
recitations13314203recitations
recreation12413613recreation
redaction1259663redaction
reduction1259903reduction
reedition1047833reedition
refection141512283refection
reflations13311233reflations
refraction15137903refraction
refutations1448673refutations
registration1347533registration
regulation11312053regulation
reiteration11412163reiteration
rejection181710253rejection
relations92418333re_lations
relaxation1746453relaxation
relegation11610023relegation
reliction11310693reliction
relocation12312113relocation
reluctation1347963reluctation
remotion10410233re_motion
rendition1058933rendition
renovation1358783renovation
reparation12612723reparation
repetition1278233repetition
repletion1147693repletion
reputations13410733reputations
reseason844933resea_son
reseating102421533reseating
resections121513033resections
reservation1489143reservation
resignation1247473resignation
reslating102516993reslating
resolution1097733resolution
resorption1247253resorption
respiration13511193respiration
restaging112410853restaging
restarting11310663restarting
restate73824883restat__e
restated93120183restat_ed
restates83423433restat_es
restationing1354263restationing
restitution1175973restitution
restorations12410953restorations
restrain8311703restrai_n
restriction1349363restriction
resumption14124733resumption
retain64523283re_ta_i_n
retention91611483retention
retortion949673retortion
retraction121310533retraction
revelation13410923revelation
revocation15410813revocation
rogation91612053r_ogation
rotations91613843r_otations
ruination9311273ruination
rustication1349223rustication
saltation9312003saltation
sedation9312453se_dation
sensation9510583sensation
seriation9318063seriation
serration9414073serration
siltation939213siltation
statin63921473__stati_n
stations82415223__stations
substation1248993substation
temptation1446383temptation
testator847373testat_or
vegetation1448213vegetation
venation11513503ve_nation
vernation12311083vernation
vexation1838783ve_xation
visitation1348593visitation
workstation1852303workstation

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 Filter1786911486410.410435831.7
2DLD Change Limit1486411856.87321626.8
3Display Results1851850.0762434.2
 (SQL Overall)1786911857.35924282.0
 
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.